=IF(G44=0,H44,0)

--
Best Regards,

Luke M
"Cerealkiller via OfficeKB.com" <u59737@uwe wrote in message
news:a8b17939cf7a4@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.a...excel/201005/1