|I have to do a nested if for the following:|
Its 5 ifs functions:
8. On the Bonuses worksheet in cells F3:F31 (Bonus column), calculate bonuses for CT (consultants) and PM (project managers). Using a nested IF calculate the following (Hint: do not use the function AND because if they employee is not a consultant (CT), they MUST be a Project Manager (PM):
a. Consultants receive $100 bonus
b. Project managers have their bonuses based on how much under budget their project is (column L of the Project Info table):
i. 40% or more under budget gets $1000
ii. From 20% to less than 40% under budget gets $500
iii. From 0% to less than 20% under budget receives $250
iv. And all projects over budget (or less than 0%) receive nothing
I know this means there would be 4 Ifs and Ive tried this:
=IF(C3="CT","1000",IF(C3="PM",E3>=40%,"1000",IF(C3="PM", E3=20%<40%,"500", IF(C3="PM", E3<20%,"250","Over Budget"
and it says too many arguments, pls help!