Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiple Variable Formula Help | Excel Worksheet Functions | |||
Multiple Variable Formula | Excel Discussion (Misc queries) | |||
Multiple variable issue | Excel Discussion (Misc queries) | |||
Help - Pivot with multiple variable | Excel Worksheet Functions | |||
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions |