IF Function On excel

September 28, 2009 at 15:16:01
Specs: Windows XP
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!


See More: IF Function On excel

Report •


#1
September 28, 2009 at 15:29:13
This isn't an xp issue. Try the Office forum

Report •
Related Solutions


Ask Question