software

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 quot;0quot; regardless, the second the correct amount and the third quot;0quot;.

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

Marc
So where are the statements?

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

quot;Marcquot; gt; wrote in message
. net...
gt; They are basically the same statement only the false statement is
gt; different
gt; but all the cells false statement formula are correct the first statement
gt; returns quot;0quot; regardless, the second the correct amount and the third quot;0quot;.
gt;
gt; I have tried moving the formula to different cell and the same thing
gt; happens.
gt;
gt; Marc
gt;
gt;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

quot;Peo Sjoblomquot; gt; wrote in message
...
gt; So where are the statements?
gt;
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Northwest Excel Solutions
gt;
gt; www.nwexcelsolutions.com
gt;
gt; (remove ^^ from email address)
gt;
gt; Portland, Oregon
gt;
gt;
gt;
gt;
gt; quot;Marcquot; gt; wrote in message
gt; . net...
gt; gt; They are basically the same statement only the false statement is
gt; gt; different
gt; gt; but all the cells false statement formula are correct the first
statement
gt; gt; returns quot;0quot; regardless, the second the correct amount and the third quot;0quot;.
gt; gt;
gt; gt; I have tried moving the formula to different cell and the same thing
gt; gt; happens.
gt; gt;
gt; gt; Marc
gt; gt;
gt; gt;
gt;
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

quot;Marcquot; gt; wrote in message nk.net...
gt; Here are the 3 statements out of 3 copies of the same workbook the first
gt; set
gt; of three works the others do not.
gt;
gt; =IF(B26 B27 B28=0,0,(G46 G72 G98 G124))
gt;
gt; =IF(B26 B27 B28=0,0,(E45 E71 E97 E123))
gt;
gt; =IF(B26 B27 B28=0,0,(G45 G71 G97 G123))
gt;
gt; =IF(B26 B27 B28=0,0,(G46 G72 G98 G124))
gt;
gt; =IF(B26 B27 B28=0,0,(E45 E71 E97 E123))
gt;
gt; =IF(B26 B27 B28=0,0,(G45 G71 G97 G123))
gt;
gt; =IF(B26 B27 B28=0,0,(G46 G72 G98 G124))
gt;
gt; =IF(B26 B27 B28=0,0,(E45 E71 E97 E123))
gt;
gt; =IF(B26 B27 B28=0,0,(G45 G71 G97 G123))
gt;
gt; Maybe I've looked at this to long but they look identical
gt;
gt; Marc
gt;
gt; quot;Peo Sjoblomquot; gt; wrote in message
gt; ...
gt;gt; So where are the statements?
gt;gt;
gt;gt; --
gt;gt;
gt;gt; Regards,
gt;gt;
gt;gt; Peo Sjoblom
gt;gt;
gt;gt; Northwest Excel Solutions
gt;gt;
gt;gt; www.nwexcelsolutions.com
gt;gt;
gt;gt; (remove ^^ from email address)
gt;gt;
gt;gt; Portland, Oregon
gt;gt;
gt;gt;
gt;gt;
gt;gt;
gt;gt; quot;Marcquot; gt; wrote in message
gt;gt; . net...
gt;gt; gt; They are basically the same statement only the false statement is
gt;gt; gt; different
gt;gt; gt; but all the cells false statement formula are correct the first
gt; statement
gt;gt; gt; returns quot;0quot; regardless, the second the correct amount and the third
gt;gt; gt; quot;0quot;.
gt;gt; gt;
gt;gt; gt; I have tried moving the formula to different cell and the same thing
gt;gt; gt; happens.
gt;gt; gt;
gt;gt; gt; Marc
gt;gt; gt;
gt;gt; gt;
gt;gt;
gt;
gt;No their in three different spread sheets but all are copies of the master.
I've Camp;P the formulas to different cells and they don't work and I've Camp;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

quot;Peo Sjoblomquot; gt; wrote in message
...
gt; They definitely return the same result for me if I play around with some
gt; numbers, no difference at all
gt; What happens if you press F9? Are they on the same sheet?
gt; --
gt;
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Northwest Excel Solutions
gt;
gt; www.nwexcelsolutions.com
gt;
gt; (remove ^^ from email address)
gt;
gt; Portland, Oregon
gt;
gt;
gt;
gt;
gt; quot;Marcquot; gt; wrote in message
gt; nk.net...
gt; gt; Here are the 3 statements out of 3 copies of the same workbook the first
gt; gt; set
gt; gt; of three works the others do not.
gt; gt;
gt; gt; =IF(B26 B27 B28=0,0,(G46 G72 G98 G124))
gt; gt;
gt; gt; =IF(B26 B27 B28=0,0,(E45 E71 E97 E123))
gt; gt;
gt; gt; =IF(B26 B27 B28=0,0,(G45 G71 G97 G123))
gt; gt;
gt; gt; =IF(B26 B27 B28=0,0,(G46 G72 G98 G124))
gt; gt;
gt; gt; =IF(B26 B27 B28=0,0,(E45 E71 E97 E123))
gt; gt;
gt; gt; =IF(B26 B27 B28=0,0,(G45 G71 G97 G123))
gt; gt;
gt; gt; =IF(B26 B27 B28=0,0,(G46 G72 G98 G124))
gt; gt;
gt; gt; =IF(B26 B27 B28=0,0,(E45 E71 E97 E123))
gt; gt;
gt; gt; =IF(B26 B27 B28=0,0,(G45 G71 G97 G123))
gt; gt;
gt; gt; Maybe I've looked at this to long but they look identical
gt; gt;
gt; gt; Marc
gt; gt;
gt; gt; quot;Peo Sjoblomquot; gt; wrote in message
gt; gt; ...
gt; gt;gt; So where are the statements?
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt;
gt; gt;gt; Regards,
gt; gt;gt;
gt; gt;gt; Peo Sjoblom
gt; gt;gt;
gt; gt;gt; Northwest Excel Solutions
gt; gt;gt;
gt; gt;gt; www.nwexcelsolutions.com
gt; gt;gt;
gt; gt;gt; (remove ^^ from email address)
gt; gt;gt;
gt; gt;gt; Portland, Oregon
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Marcquot; gt; wrote in message
gt; gt;gt; . net...
gt; gt;gt; gt; They are basically the same statement only the false statement is
gt; gt;gt; gt; different
gt; gt;gt; gt; but all the cells false statement formula are correct the first
gt; gt; statement
gt; gt;gt; gt; returns quot;0quot; regardless, the second the correct amount and the third
gt; gt;gt; gt; quot;0quot;.
gt; gt;gt; gt;
gt; gt;gt; gt; I have tried moving the formula to different cell and the same thing
gt; gt;gt; gt; happens.
gt; gt;gt; gt;
gt; gt;gt; gt; Marc
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt;
gt; gt;
gt; gt;
gt;