ExcelBanter - IF Statements

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF Statements (https://www.excelbanter.com/excel-discussion-misc-queries/263746-if-statements.html)

Jillian

IF Statements

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 I6G6 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

IF Statements

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.

"Jillian" wrote:

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 I6G6 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!

All times are GMT +1. The time now is 12:56 PM.