You're welcome  thanks for feeding back.
Pete
On Jul 30, 1:33*am, "Gary" <(EMail Removed)> wrote:
> Pete, I got two good formulas. *This will work great. *Thank you for taking
> the time to help.
>
> Regards, Gary
>
> "Pete_UK" <(EMail Removed)> wrote in message
>
> news:(EMail Removed)...
> Here's one way, with your revenue in A1:
>
> =IF(A1<=10000000,70000,70000+INT(CEILING((A110000000),1000000)/
> 1000000)*5000)
>
> Hope this helps.
>
> Pete
>
> On Jul 29, 11:34 pm, "Gary" <(EMail 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 
