Using Multiple "IF" Statements to get Three Different True Values

**rehankins** · 01-15-2013, 12:03 AM

In cell C11 I have my actual earnings, and in D11 I have my budget amounts. I put an If statement together to get three possible true values: Over(budget), Under(budget), or equal. After typing in my formula, I will get return values if C11 is over or under D11 but not if it is equal. Here is my formula =IF((C11<D11),"Under",IF((C11>D11),"Over",IF((C11=D11),"Equal","")))

**benishiryo** · 01-15-2013, 12:17 AM

hi rehankins, welcome to the forum. your formula seems alright. you can shorten it by removing unnecessary brackets though:
=IF(C11<D11,"Under",IF(C11>D11,"Over",IF(C11=D11,"Equal","")))

and since there is only a possibility of 3 scenarios, and if scenario is not under of over, it must be "Equal". so it can be further shorten to:
=IF(C11<D11,"Under",IF(C11>D11,"Over","Equal"))

not actually sure what you need, but hope to have helped

**rehankins** · 01-15-2013, 12:28 AM

Thank you for the reply, benishiryo. Your answer helped simplify my formula, but it seems as if it is not picking up the "Equal". When I set the two cells equal to each other, it still states the value "Over."