Incremental Salary Adjustment Formula

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

An employee has an annual salary of $70,000 based on Company revenues of
$10,000,000 or less. What formula would work in an Excel cell for an
increase in salary of $5,000 for each $1,000,000 increase in revenue?

Example: a formula would return results of $70,000 for revenues $1 to
$10,000,000 / $75,000 for revenues $10,000,001 to $11,000,000 / $80,000 for
revenues $11,000,001 to $12,000,000 / etc.

Regards, Gary
 
=MAX(70000,70000+ROUNDUP(A1-10000000,-6)/1000000*5000)

change the reference to range a1 to the cell with the revenue amount
 
Here's one way, with your revenue in A1:

=IF(A1<=10000000,70000,70000+INT(CEILING((A1-10000000),1000000)/
1000000)*5000)

Hope this helps.

Pete
 
Pete, I got two good formulas. This will work great. Thank you for taking
the time to help.

Regards, Gary

Here's one way, with your revenue in A1:

=IF(A1<=10000000,70000,70000+INT(CEILING((A1-10000000),1000000)/
1000000)*5000)

Hope this helps.

Pete
 
Dennis, I got two good formulas. This will work great. Thank you for
taking the time to help.

Regards, Gary
 
You're welcome - thanks for feeding back.

Pete

Pete, I got two good formulas.  This will work great.  Thank you for taking
the time to help.

Regards, Gary


Here's one way, with your revenue in A1:

=IF(A1<=10000000,70000,70000+INT(CEILING((A1-10000000),1000000)/
1000000)*5000)

Hope this helps.

Pete





- Show quoted text -
Click to expand...
 
Back
Top