# IF Nested Function On excel

September 28, 2009 at 16:07:46
Specs: Excel 2007
 Hello, Pls help, cant figure this out8. 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 This is the formula I have but its not workingIF(C3="CT","\$100", IF(C3=PM,E3>=40%,"1000", IF(E3>=20%, "500", IF(e3<20%, "250",0)))) Also, this is whats on Column LDifference \$26,044 \$(57,954) \$14,073 \$24,933 \$(2,440) \$1,349 \$74,059 \$(14,131)Please help asap!!

See More: IF Nested Function On excel

#1
September 28, 2009 at 17:34:39
 Hi,I assume this is an assignment that you are meant to work out yourself.Regards

Report •

#2
September 28, 2009 at 18:23:27
 Hi,If it was an assignment, then it is for you to work out the solution and not get someone else to do it for you.If you can't work out the solution yourself, then so be it. You get a lower score than someone who can work it out. My response was not telling you what you already knew, it was me telling you that you should take responsibility for your assignment, whether or not you could solve it.There is an enormous amount of information on Excel available on the net, which is available for you to explore and use, without getting others to do your assignment.I am however glad that you solved the problem in the 90 minutes or so between posts.RegardsPS If you have two primary classes CT and PM then you only need one IF statement referring to them - it's either CT OR it's PM.If it is PM then you have a further series of IF statements,or you could use a VLOOKUP.

Report •

Related Solutions