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

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

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

So where are the statements?

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Marc" wrote in message
. net...
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

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

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

"Peo Sjoblom" wrote in message
...
So where are the statements?

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Marc" wrote in message
. net...
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

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

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




"Marc" wrote in message
nk.net...
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

"Peo Sjoblom" wrote in message
...
So where are the statements?

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Marc" wrote in message
. net...
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

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

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

"Peo Sjoblom" wrote in message
...
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




"Marc" wrote in message
nk.net...
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

"Peo Sjoblom" wrote in message
...
So where are the statements?

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Marc" wrote in message
. net...
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