IF Statements

[Jillian]

Hi, I was hoping someone would be able to assist me. I am looking for a
formula where if I6<G6 then 0 BUT if I6>G6 then I6-G6. Basically if I6 is
greater than G6 the cell needs to populate the difference. I have tried
everything and I get is #NAME? or #VALUE errors.
Thanks!

 

[Mike H]

Hi,

This should do it

=MAX(0,I6-G6)
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.