Excel - Adding and Subtracting issue
Issue
I have a row of 4 cells each containing an "if formula" to get information from another worksheet. An example of the formula in these cells is: =IF('2009'!E2>0,'2009'!E2,""). My problem is trying to find the total of these cells. I'm adding 3 and subtracting 1.
The formula I'm using is: =IF(SUM(C2,E2:F2)>0,SUM(C2-D2+E2+F2),"")
The formula works great if all 4 cells have a value in it; however, if one is blank, #VALUE! shows in the cell. Is it possible to do what I'm trying to?
Thanks for any help.
Solution
Try this it works on excel 2007 but it should work on lower excels.
=IF(D11=1,F5,IF(D11=2,F6,IF(D11>2,0)))
Thanks to
Helper for this tip on the forum.
See also
Knowledge communities.
