I need an "IF" formula, but can't seem to come up with you correctly. If C4 or D4 is "0" I want to add the other. Please help!
2007-07-27 02:58:01 · 5 answers · asked by donna_starkey 1 in Computers & Internet ➔ Software
Since there is no cell reference of DF or EF in Excel, we will assume your original formula is:
B4 + C4 + D4 - E4 = F4
and that if neither C4 or D4 is zero then add them both.
You need to nest two if statements.
if(c4=0, B4+D4-E4, if(D4=0, B4+C4-E4, B4+C4+D4-E4))
That should do it.
2007-07-27 03:27:41 · answer #1 · answered by vbmica 7 · 1⤊ 0⤋
Not sure exactly what your formula is supposed to do.
However, I can give a basic framework that should help
=IF(C4=0,D4+E4+FA4,C4+D4+E4)
That is assuming that either C4 or D4 will always be 0.
2007-07-27 03:06:20 · answer #2 · answered by wyntre_2000 5 · 1⤊ 0⤋
if other = 0 c4 or d4 = f4
2007-07-27 03:05:34 · answer #3 · answered by mammalia_monkey 4 · 0⤊ 1⤋
try this, I had to split line so it the whole formula would appear. type all of this in one cell.
=IF(A213=0,SUM(A211:D211)
,IF(A214=0,SUM(A211:D211),"")).
THIS SHOULD WORK! type formula in any other cell and enter data into all 6 cells. if A213 or 214=0, it will give you an empty cell for result, otherwise it will add A211 TO D211. if you put anything between "" , it will put that in the cell.
2007-07-27 05:47:37 · answer #4 · answered by clinky 3 · 0⤊ 0⤋
What would you want to do if neither is zero?
Because if you want to add the non-zero ones, you might as well add both, because adding zero to something doesn't change the result...
2007-07-27 03:04:05 · answer #5 · answered by Uninformed hence not consenting 7 · 1⤊ 0⤋