IF Statements

  • Thread starter Thread starter Jillian
  • Start date Start date
J

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