PC Review


Reply
Thread Tools Rate Thread

Incremental Salary Adjustment Formula

 
 
Gary
Guest
Posts: n/a
 
      29th Jul 2009
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

 
Reply With Quote
 
 
 
 
Dennis Chou
Guest
Posts: n/a
 
      30th Jul 2009
=MAX(70000,70000+ROUNDUP(A1-10000000,-6)/1000000*5000)

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

"Gary" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>



 
Reply With Quote
 
 
 
 
Pete_UK
Guest
Posts: n/a
 
      30th Jul 2009
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

On Jul 29, 11:34*pm, "Gary" <(E-Mail Removed)> wrote:
> 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


 
Reply With Quote
 
Gary
Guest
Posts: n/a
 
      30th Jul 2009
Pete, I got two good formulas. This will work great. Thank you for taking
the time to help.

Regards, Gary

"Pete_UK" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
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

On Jul 29, 11:34 pm, "Gary" <(E-Mail Removed)> wrote:
> 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


 
Reply With Quote
 
Gary
Guest
Posts: n/a
 
      30th Jul 2009
Dennis, I got two good formulas. This will work great. Thank you for
taking the time to help.

Regards, Gary

"Dennis Chou" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> =MAX(70000,70000+ROUNDUP(A1-10000000,-6)/1000000*5000)
>
> change the reference to range a1 to the cell with the revenue amount
>
> "Gary" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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
>>

>
>


 
Reply With Quote
 
Pete_UK
Guest
Posts: n/a
 
      30th Jul 2009
You're welcome - thanks for feeding back.

Pete

On Jul 30, 1:33*am, "Gary" <(E-Mail Removed)> wrote:
> Pete, I got two good formulas. *This will work great. *Thank you for taking
> the time to help.
>
> Regards, Gary
>
> "Pete_UK" <(E-Mail Removed)> wrote in message
>
> news:(E-Mail Removed)...
> 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
>
> On Jul 29, 11:34 pm, "Gary" <(E-Mail Removed)> wrote:
>
>
>
> > 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- Hide quoted text -

>
> - Show quoted text -


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
calculate diffence between old salary and new salary Felicia Pickett Microsoft Excel Worksheet Functions 3 6th Apr 2010 04:32 PM
Salary Tax Formula, NOORZAD Microsoft Excel Discussion 5 25th Jun 2009 01:36 AM
salary adjustment due to inflation,,how to ?? =?Utf-8?B?ZHJpbGxlcg==?= Microsoft Excel Worksheet Functions 1 10th May 2007 10:50 AM
help writing formula to determine salary/overtime sockmodel7 Microsoft Excel Misc 2 6th Dec 2005 05:32 PM
Help with formula to canculate Post-tax vs. Pre-tax salary Thuy Microsoft Excel Misc 6 27th Aug 2004 08:38 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:31 AM.