If statment
in [General]
|
From: Cerealkiller via OfficeKB.com on 28 May 2010 15:18 If g44 equals 0 then h44 it is returning it as false maybe i am missing something =IF(G44=0,H44) -- Message posted via http://www.officekb.com
From: Luke M on 28 May 2010 15:29 What happens if G44 <> 0? =IF(G44=0,H44,"Criteria not met") -- Best Regards, Luke M "Cerealkiller via OfficeKB.com" <u59737(a)uwe> wrote in message news:a8b14b1d7b679(a)uwe... > If g44 equals 0 then h44 it is returning it as false maybe i am missing > something > > =IF(G44=0,H44) > > -- > Message posted via http://www.officekb.com >
From: Cerealkiller via OfficeKB.com on 28 May 2010 15:38 Luke M wrote: >What happens if G44 <> 0? >=IF(G44=0,H44,"Criteria not met") > >> If g44 equals 0 then h44 it is returning it as false maybe i am missing >> something >> >> =IF(G44=0,H44) If G44 is <> I do nto want it to do anything I want a 0 in the cell so maybe If g44 equals 0 then h44 if g44 is <> then 0 I am not sure if that make sense -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.aspx/ms-excel/201005/1
From: Luke M on 28 May 2010 15:57 =IF(G44=0,H44,0) -- Best Regards, Luke M "Cerealkiller via OfficeKB.com" <u59737(a)uwe> wrote in message news:a8b17939cf7a4(a)uwe... > Luke M wrote: >>What happens if G44 <> 0? >>=IF(G44=0,H44,"Criteria not met") >> >>> If g44 equals 0 then h44 it is returning it as false maybe i am missing >>> something >>> >>> =IF(G44=0,H44) > > If G44 is <> I do nto want it to do anything I want a 0 in the cell > > so maybe If g44 equals 0 then h44 if g44 is <> then 0 I am not sure if > that > make sense > > -- > Message posted via OfficeKB.com > http://www.officekb.com/Uwe/Forums.aspx/ms-excel/201005/1 >
From: Gord Dibben on 28 May 2010 16:28
=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 On Fri, 28 May 2010 19:18:00 GMT, "Cerealkiller via OfficeKB.com" <u59737(a)uwe> wrote: >If g44 equals 0 then h44 it is returning it as false maybe i am missing >something > >=IF(G44=0,H44) |