Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am stuck with the IF statement under 3 different senarios. Please HELP!
A1=Y B1=Director or Manager or Worker C1=2 or 1.5 or 1 D1=year of service If A1=Y and he is Director, he will get 2 weeks pay (C1) times D1 and cap at 12 years (24 weeks). But if A1=Y and he is a Manager, he will get 1.5 weeks pay (C1) times D1 and cap at 12 years (18 weeks). But if A1=Y and he is a Worker, he will get 1 week pay (C1) times (D1). How do I put all 3 IF together? It should be something like =IF(AND(A1="Y",B1="Director" and D1<12),C1*D1,24; and so on. But don't know how to link all 3 together. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with If statment | Excel Discussion (Misc queries) | |||
If statment | Excel Discussion (Misc queries) | |||
if statment | Excel Worksheet Functions | |||
If statment if its possible. | Excel Discussion (Misc queries) | |||
If statment | Excel Worksheet Functions |