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

1. ### GaryGuest

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

2. ### Dennis ChouGuest

=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

3. ### Pete_UKGuest

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
4. ### GaryGuest

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
5. ### GaryGuest

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
6. ### Pete_UKGuest

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