Incremental Salary Adjustment Formula

Discussion in 'Microsoft Excel Discussion' started by Gary, Jul 29, 2009.

  1. Gary

    Gary Guest

    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
     
    Gary, Jul 29, 2009
    #1
    1. Advertisements

  2. Gary

    Dennis Chou Guest

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

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

    "Gary" <> wrote in message
    news:...
    > 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, Jul 30, 2009
    #2
    1. Advertisements

  3. Gary

    Pete_UK Guest

    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" <> 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
     
    Pete_UK, Jul 30, 2009
    #3
  4. Gary

    Gary Guest

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

    Regards, Gary

    "Pete_UK" <> wrote in message
    news:...
    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" <> 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
     
    Gary, Jul 30, 2009
    #4
  5. Gary

    Gary Guest

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

    Regards, Gary

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

    >
    >
     
    Gary, Jul 30, 2009
    #5
  6. Gary

    Pete_UK Guest

    You're welcome - thanks for feeding back.

    Pete

    On Jul 30, 1:33 am, "Gary" <> wrote:
    > Pete, I got two good formulas.  This will work great.  Thank you for taking
    > the time to help.
    >
    > Regards, Gary
    >
    > "Pete_UK" <> wrote in message
    >
    > news:...
    > 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" <> 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 -
     
    Pete_UK, Jul 30, 2009
    #6
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Benelly

    Row height - automatic adjustment

    Benelly, Sep 6, 2004, in forum: Microsoft Excel Discussion
    Replies:
    6
    Views:
    508
    Benelly
    Sep 7, 2004
  2. Andrew

    Preventing automatic adjustment of formual reference

    Andrew, Nov 15, 2004, in forum: Microsoft Excel Discussion
    Replies:
    3
    Views:
    260
    Guest
    Nov 15, 2004
  3. Khalil Handal

    Macro adjustment

    Khalil Handal, Mar 17, 2006, in forum: Microsoft Excel Discussion
    Replies:
    1
    Views:
    261
    Dave Peterson
    Mar 18, 2006
  4. Guest

    Column Width Adjustment

    Guest, Apr 9, 2006, in forum: Microsoft Excel Discussion
    Replies:
    3
    Views:
    232
    Bruce Sinclair
    Apr 12, 2006
  5. Khalil handal

    Array Formula Adjustment

    Khalil handal, Sep 2, 2008, in forum: Microsoft Excel Discussion
    Replies:
    2
    Views:
    242
    Khalil Handal
    Sep 2, 2008
  6. Craig Schiller

    Formula for incremental cell reference

    Craig Schiller, Sep 22, 2008, in forum: Microsoft Excel Discussion
    Replies:
    13
    Views:
    347
    AltaEgo
    Sep 24, 2008
  7. calculation to insert salary based on position title

    , Oct 27, 2008, in forum: Microsoft Excel Discussion
    Replies:
    3
    Views:
    256
    bostontj98
    Oct 28, 2008
  8. NOORZAD

    Salary Tax Formula,

    NOORZAD, Jun 24, 2009, in forum: Microsoft Excel Discussion
    Replies:
    5
    Views:
    780
    AltaEgo
    Jun 25, 2009
Loading...