If statment

  • Thread starter Cerealkiller via OfficeKB.com
  • Start date
C

Cerealkiller via OfficeKB.com

If g44 equals 0 then h44 it is returning it as false maybe i am missing
something

=IF(G44=0,H44)
 
C

Cerealkiller via OfficeKB.com

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
 
L

Luke M

=IF(G44=0,H44,0)

--
Best Regards,

Luke M
Cerealkiller via OfficeKB.com said:
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
Click to expand...
 
G

Gord Dibben

=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
 
C

Cerealkiller via OfficeKB.com

Gord said:
=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
Click to expand...


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.
 
Top