use this

=IF(I12="MRM",G12*P3,IF(I12="ME",G12*P4,IF(I12="AB ",G12*P5,"")))




On May 30, 5:34*pm, Mtavares
wrote:
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