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:
    402
    Benelly
    Sep 7, 2004
  2. Khalil handal

    Array Formula Adjustment

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

    Formula for incremental cell reference

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

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

    Salary Tax Formula,

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

Share This Page