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

[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

[Peo Sjoblom]

So where are the statements?

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Marc" <mcnr(N_O-S_P_A_M)@mindspring.com> wrote in message
news:ULFYf.76$sq5.18@newsread2.news.atl.earthlink.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
>
>

[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

"Peo Sjoblom" <peo.sjoblom@^^nwexcelsolutions.com> wrote in message
news:u4pkVnFWGHA.404@TK2MSFTNGP05.phx.gbl...
> So where are the statements?
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> Northwest Excel Solutions
>
> www.nwexcelsolutions.com
>
> (remove ^^ from email address)
>
> Portland, Oregon
>
>
>
>
> "Marc" <mcnr(N_O-S_P_A_M)@mindspring.com> wrote in message
> news:ULFYf.76$sq5.18@newsread2.news.atl.earthlink.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
> >
> >
>

[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




"Marc" <mcnr(N_O-S_P_A_M)@mindspring.com> wrote in message
news:YhIYf.3138$i41.221@newsread1.news.atl.earthlink.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" <peo.sjoblom@^^nwexcelsolutions.com> wrote in message
> news:u4pkVnFWGHA.404@TK2MSFTNGP05.phx.gbl...
>> So where are the statements?
>>
>> --
>>
>> Regards,
>>
>> Peo Sjoblom
>>
>> Northwest Excel Solutions
>>
>> www.nwexcelsolutions.com
>>
>> (remove ^^ from email address)
>>
>> Portland, Oregon
>>
>>
>>
>>
>> "Marc" <mcnr(N_O-S_P_A_M)@mindspring.com> wrote in message
>> news:ULFYf.76$sq5.18@newsread2.news.atl.earthlink.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
>> >
>> >
>>
>
>

[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

"Peo Sjoblom" <peo.sjoblom@^^nwexcelsolutions.com> wrote in message
news:%23fiahHHWGHA.4292@TK2MSFTNGP04.phx.gbl...
> 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" <mcnr(N_O-S_P_A_M)@mindspring.com> wrote in message
> news:YhIYf.3138$i41.221@newsread1.news.atl.earthlink.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" <peo.sjoblom@^^nwexcelsolutions.com> wrote in message
> > news:u4pkVnFWGHA.404@TK2MSFTNGP05.phx.gbl...
> >> So where are the statements?
> >>
> >> --
> >>
> >> Regards,
> >>
> >> Peo Sjoblom
> >>
> >> Northwest Excel Solutions
> >>
> >> www.nwexcelsolutions.com
> >>
> >> (remove ^^ from email address)
> >>
> >> Portland, Oregon
> >>
> >>
> >>
> >>
> >> "Marc" <mcnr(N_O-S_P_A_M)@mindspring.com> wrote in message
> >> news:ULFYf.76$sq5.18@newsread2.news.atl.earthlink.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
> >> >
> >> >
> >>
> >
> >
>