greater than or equal formula

steve daddario said:

Hello,

Im trying to figure out how I can set up a formula so that when a planned target profit is reached i can add a 10% bonus to that persons salary. For example, in Q1 planned sales were $87500 and Actual was $100000. How could i make a formula to calculate that this is greter than or equal to our Planned sales and that the manager whose salary is 50000 gets a 10% bonus. I know it is confusing but any ideas.

Thanks for the help.

Click to expand...

steve daddario said:

Hello,

Im trying to figure out how I can set up a formula so that when a planned target profit is reached i can add a 10% bonus to that persons salary. For example, in Q1 planned sales were $87500 and Actual was $100000. How could i make a formula to calculate that this is greter than or equal to our Planned sales and that the manager whose salary is 50000 gets a 10% bonus. I know it is confusing but any ideas.

Thanks for the help.

Click to expand...

steve daddario said:

10% of the 50000 which is the managers salary so he would recice a 5000 dollar bonus. let me know if you have any more questions

Click to expand...