IF Function Help

I

IHateComputers

I have a project that requires me to calculate bonuses for employees. I am
pretty sure that I need to use an IF function. Here is the question:

If the project fees do not exceed estimates the manager receives an 100
bonus. Algebraically, this is Bonus=(actual-projected)*bonus rate if
(actual-projected)>0, 100 otherwise. Create a formula that calculates the
project manager bonus.

This is a completely different language that I just can't seem to decipher.
If anyone can help, that would be great!
 
R

Rick Rothstein \(MVP - VB\)

Or even...

=MAX(100,(Actual - Projected) * BonusRate)

which is a more fair formula (for the manager) than the one you posted (if
the difference times the bonus rate is less than 100, your formula gives the
manager the smaller amount).

Rick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top