IF Function - 3 Conditions

[takeawalkk]

So I'm trying to do an IF function based on 3 conditions

If Cell F <= I3*1.10,"Value if True", if(F > I, "Value if True", "Value if False"))

What I'm trying to do is:

If annual is greater than budget but only by budget * 1.10 then populate a value
If annual is greater than budget by more than budget *1.10 then populate a value
and if annual greater than budget then populate a value

im trying to do multiple ifs but it only populates one value..

any help would be greatly appreciated

[dflak]

IF will return only one value: that which is associated with the first condition that is satisfied. Once it finds what it is looking for, it stops looking even though subsequent conditions may also be true.

In your case you might have to use some AND Statements. if(AND(F>I,F <= I*1.3),Value 1),if(F>I*1.3,Value 2,Value 3))

So this means if annual is greater than budget AND less than or equal to 1.3 Budget use Value 1.
else
if annual > 1.3 Budget than us Value 2.
else
the only possibility left is that annual is less than budget, in which case use Value 3.

-=edit=-

I just looked at this and decided that an easier formula (and cleaner logic) is

IF (F<I , Value 1, IF (F<=1.3 * I, Value 2, Value 3))

if annual is less than budget, use value 1

if annual is less than 1.3 * budget, use value 2 - we've already eliminated the possibility that annual is less than budget, because if it were, the if statement would have stopped before it got here.

The only possibility left is that annual is > 1,3 * budget. Use Value 3.

[takeawalkk]

Still the same result - column F is budget and column I is actual.

So what the result is that if I < F its not populating "under budget" instead, its populating, within 10% of budget. even though its less than budget

[takeawalkk]

Thanks it worked actually!