IF Nested Function On excel

September 28, 2009 at 16:07:46
Specs: Excel 2007
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


Please help asap!!

See More: IF Nested Function On excel

Report •

September 28, 2009 at 17:34:39

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


Report •

September 28, 2009 at 18:23:27

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.

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.

Report •

Related Solutions

Ask Question