can any one solve this one?

[steve daddario]

Hey,

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 when actual sales are greater than or equal to the planned amount the manager salary recieves a 10% bonus. So if i have Q1 Q2 Q3 Q4 i wanna know how i can make a formula to pay my manager 10% bonus each quater he reaches his target profit.

manage makes 50000 in salary plus 10% bonus each quater if meets TP.

Anyonee???

thanks

 

[Ralajer]

For example
A2 = Planned Sales
B2 = Actual Sales
C2 = Salary
D2 = Formula (Salary with Bonus)

=C2*(1+IF(B2>A2,0.1,0))

The IF statement checks if the Actual is greater than Planned when True return 0.1 or 10% but when False it returns 0.

Actual > Planned then 50000 *(1+0.1) = 50000*(1.1) = 55000
Actual < Planned then 50000*(1+0) = 50000*(1) = 50000

it could also be written like
=IF(B2>A2,1.1*C2,C2)

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/showthread.php?t=556099

Please do not post the same question multiple times. Any directly related follow-ups, clarificaitons, or bumps should be posted back to the original thread. Per forum rules, threads of a duplicate nature are typically locked or deleted (http://www.mrexcel.com/forum/showthread.php?t=99490).