I'm trying to put these two formulas into a single cell.
=IF(E3 < 1," "," ")
F2-SUM(E1:E3)
The first so that the cell will display (or at least look) blank if it's not retrieving any data.
How could I combine these?
I'm trying to put these two formulas into a single cell.
=IF(E3 < 1," "," ")
F2-SUM(E1:E3)
The first so that the cell will display (or at least look) blank if it's not retrieving any data.
How could I combine these?
You could do something like this
=IF(E3>0,F2-SUM(E1:E3),"")
that returns a blank unless E3>0 in which case your calculation is triggered. If you expect numbers in all 4 cells you could also use a formula like:
=IF(COUNT(F2,E1:E3)=4,F2-SUM(E1:E3),"")
Thank you very much for the quick reply!
edit:
First formula works perfectly. Awesome
Last edited by Deltaeagle; 07-10-2009 at 09:06 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks