Hello, Pls help, cant figure this out 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 This is the formula I have but its not working IF(C3="CT","$100", IF(C3=PM,E3>=40%,"1000", IF(E3>=20%, "500", IF(e3<20%, "250",0)))) Also, this is whats on Column L Difference $26,044 $(57,954) $14,073 $24,933 $(2,440) $1,349 $74,059 $(14,131) Please help asap!!

Hi, I assume this is an assignment that you are meant to work out yourself. Regards

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. Regards PS 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.