How to Subtract value in table, based on two different conditions

		Microsoft Office Forums > Microsoft Excel > Excel
How to Subtract value in table, based on two different conditions

FAQ

Thread Tools

Display Modes

06-19-2015, 01:28 AM

Catalin.B

Windows Vista How to Subtract value in table, based on two different conditions

Office 2010 32bit

Expert

Join Date: May 2011

Location: Iaşi, România

Posts: 386

Hi,
Try this formula in cell E16, copied down and to the right:
=INDEX($A$2:$E$5,MATCH($D16,$A$2:$A$5,0),MATCH(E$1 5,$A$2:$E$2,0))-IF(E$15>=$H$12,INDEX($J$2:$M$4,MATCH($D$12,$J$2:$J $4,0),MATCH($D16,$J$2:$M$2,0)),0)

Cheers,

Attached Files

Copy of Subtract value based on two different conditions.xlsx (9.5 KB, 10 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Table, font color based on what word is in cell	donaldadams1951	Word Tables	1	04-15-2015 08:37 PM
How to Extract Data from table based on pattern.	PRA007	Word Tables	4	03-17-2015 11:05 PM
update one embedded excel table based on another excel table	ajetrumpet	Word	0	07-05-2013 08:51 PM
Update Word table based on another table input	mpdsal	Word VBA	10	10-29-2012 07:40 AM
Formula to subtract one month from due date field in reminder field	ghumdinger	Outlook	1	10-01-2011 12:09 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:19 PM.