Incremental Salary Adjustment Formula

[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

 

[Dennis Chou]

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

change the reference to range a1 to the cell with the revenue amount

 

[Pete_UK]

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

 

[Gary]

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

 

[Gary]

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

Regards, Gary

 

[Pete_UK]

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 -