Prev: Text to Column will not cooperate
Next: combine formulas into 1
From: Cerealkiller via OfficeKB.com on 28 May 2010 17:09
Gord Dibben wrote:
>=IF(G44=0,H44) returns H44 value if G4 is 0
>
>Are you sure g44 is 0 or just formatted to show whole number?
>
>Maybe value is 0.0000000012 or similar?
>
>What happens when you use this formula?
>
>=IF(G44=0,H44,"not zero")
>
>Gord Dibben MS Excel MVP
>
>>If g44 equals 0 then h44 it is returning it as false maybe i am missing
>>something
>>
>>=IF(G44=0,H44)


Thank you the value was wrong. I thought I had the formula right but
sometimes you just need and outside look. Thank you againe now it works.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/ms-excel/201005/1

First  |  Prev  | 
Pages: 1 2
Prev: Text to Column will not cooperate
Next: combine formulas into 1