View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mtavares Mtavares is offline
external usenet poster
 
Posts: 3
Default IF with multiple formula/variable

I'm trying to use IF with other variable but is not working.

What I have:

Colum G12 - NET Sallary
Colum I12 - 3 possibilities (MRM, ME, AB)
Colum J12 where I will have my formula.

I have another table with 3 datas:

MRM = 1,308 (P3)
ME = 1,566 (P4)
AB = 1,630 (P5)

What I need to do is the following:

J12 = IF I12 = "MRM" THAN G12*P3; IF I12 = "ME" THAN G12*P4; IF I12 = "AB"
THAN G12*P5

I need to multiply the sallary to one of the 3 variable depending on the
category: MRM, ME and AB.

Anybody knows if this is possible and how to do it?

Thanks in advance.

Marcus