I'm having a really strange problem with 3 if statements.

M

Marc

They are basically the same statement only the false statement is different
but all the cells false statement formula are correct the first statement
returns "0" regardless, the second the correct amount and the third "0".

I have tried moving the formula to different cell and the same thing
happens.

Marc
 
M

Marc

Here are the 3 statements out of 3 copies of the same workbook the first set
of three works the others do not.

=IF(B26+B27+B28=0,0,(G46+G72+G98+G124))

=IF(B26+B27+B28=0,0,(E45+E71+E97+E123))

=IF(B26+B27+B28=0,0,(G45+G71+G97+G123))

=IF(B26+B27+B28=0,0,(G46+G72+G98+G124))

=IF(B26+B27+B28=0,0,(E45+E71+E97+E123))

=IF(B26+B27+B28=0,0,(G45+G71+G97+G123))

=IF(B26+B27+B28=0,0,(G46+G72+G98+G124))

=IF(B26+B27+B28=0,0,(E45+E71+E97+E123))

=IF(B26+B27+B28=0,0,(G45+G71+G97+G123))

Maybe I've looked at this to long but they look identical

Marc
 
P

Peo Sjoblom

They definitely return the same result for me if I play around with some
numbers, no difference at all
What happens if you press F9? Are they on the same sheet?
--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon
 
M

Marc

No their in three different spread sheets but all are copies of the master.
I've C&P the formulas to different cells and they don't work and I've C&P
the formula from the sheet that works to the ones that don't and they don't
work. Could the workbook have become corrupted in some way?

Marc
 
Top