Struggling with IF

**KClark** · 08-06-2011, 04:27 PM

Can someone help me?

Here's my IF function

=IF(B9="PM",(C9*114.16),IF(B9="SE",(C9*100)))

This works when I put PM in cell B9 but when I select SE it places a "False" in the cell. What am I doing wrong?

I have several different pay grades to place in the B9 cell and when I enter the different pay grade I need C9 to muliple by their respective hourly rate. In this case the PM rate is $114.16.

Please Help!

**JBeaucaire** · 08-06-2011, 05:02 PM

Create an alphabetical "array" of the codes, then a matching array of the rates, then use those arrays in a normal LOOKUP() formula:

=C9 * LOOKUP(B9, {"AR", "PM", "SE"}, {95, 114.16, 100})

Another way, you could create a TABLE on your sheet somewhere, perhaps columns AA:AB

    AA   AB
1   AR   95
2   PM   114.16
3   SE   100
4   XX   125

...then use a VLOOKUP against that table:

=C9 * VLOOKUP(B9, $AA:$AB, 2, 0)

With this method, the table would not have to be alphabetical.

**kvsrinivasamurthy** · 08-10-2011, 02:46 AM

hI
In your formula you have not decided if B9<>"PM" or "SE".ie in second IF B9="SE" gives C9*100 If B9<>"SE" what is value.Asuming that IF B9<>"SE" the value is C9*50 the formula changed is below.Make suitable change required.
hope it works.

=IF(B9="PM",(C9*114.16),IF(B9="SE",(C9*100),C9*50))

**nazmul_muneer** · 08-10-2011, 04:37 AM

Actually your formula is correct.
I think you select "PM" and "SE" from list.
See where you type "SE", it is not exactly SE, it may be " SE" or "SE "
Plz see again

Muneer