IF function with 3 possible outcomes

**lee_s** · 04-09-2012, 12:22 PM

I need to use an IF function but require 3 possible outcomes (if that makes sense)

IF O2 > 8.5 = £125
IF O2 < 8.5 BUT > 8.0 = £75
IF O2 < 8.0 = £0

Please could someone direct me on what I need to do, I have tried nested IF formula's but don't seem to be able to get it to work.

Thanks in advance,

Lee

**Bob Phillips** · 04-09-2012, 12:24 PM

Try

=IF(O2<8,0,IF(O2<8.5,75,125))

and format as £

**zbor** · 04-09-2012, 12:25 PM

Try =IF(O2>8.5, 125, IF(O2<8, 0, 75))

**JieJenn** · 04-09-2012, 12:26 PM

You forgot to mention what happen when O2 = the criteria. Anyway, try the formula, and modify it based on your specifics.

=IF(O2>=8.5,125,IF(AND(O2<8.5,O2>=8),75,IF(O2<8,0,"")))