Hi


"Biff" <biffinpitt@comcast.net> wrote in message
news:e1mJOKHpFHA.2152@TK2MSFTNGP14.phx.gbl...
> Hi!
>
> You have a conflict in logic here!
>
> If Bill Gates sales are $1 billion his bonus could be either/or by your
> description!
>
> The best solution to this depends on how many conditions there are. Just
> using the 2 you posted:
>
> Let's make the levels logic friendly:
>
> 1 billion or greater = 15%
> Less than 1 billion = 10%
>
> A1 = sales
>
> Formula to calculate bonus:
>
> =IF(A1>=1000^3,A1*0.15,A1*0.1)

Or
=A1*(0.1+(A1>=1000000)*0.05)

For
less than 1000 =0%
less than 1000000 =10%
1000000 or greater =15%
=A1*((A1>=1000)*0.1+(A1>=1000000)*0.05)

For
less than 1000 =0%
less than 10000 =2%
less than 100000 =5%
less than 1000000 =10%
1000000 or greater =15%
=A1*((A1>=1000)*0.02+(A1>=10000)*0.03+(A1>=1000)*0.05+(A1>=1000000)*0.05)

etc.


--
Arvi Laanemets
( My real mail address: arvil<at>tarkon.ee )