Ask a question »

Excel - Adding and Subtracting issue

May 2015


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.
For unlimited offline reading, you can download this article for free in PDF format:
Excel-adding-and-subtracting-issue.pdf

See also

In the same category

Published by aakai1056.
This document entitled « Excel - Adding and Subtracting issue » from Kioskea (en.kioskea.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.