IF with multiple formula/variable

[Marcus Tavares]

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,709 (P3)
ME = 1,544 (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?

Thanks in advance.

Marcus

 

[Stormseed]

Good Lord !! glad to know that !