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 bonusb. 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 \$1000ii. From 20% to less than 40% under budget gets \$500iii. From 0% to less than 20% under budget receives \$250iv. 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

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

Report •
Related Solutions