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

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
>

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

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

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
>>

>
>

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 -

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 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 OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post Felicia Pickett Microsoft Excel Worksheet Functions 3 6th Apr 2010 04:32 PM NOORZAD Microsoft Excel Discussion 5 25th Jun 2009 01:36 AM =?Utf-8?B?ZHJpbGxlcg==?= Microsoft Excel Worksheet Functions 1 10th May 2007 10:50 AM sockmodel7 Microsoft Excel Misc 2 6th Dec 2005 05:32 PM Thuy Microsoft Excel Misc 6 27th Aug 2004 08:38 AM

Features