I have untill about 10am sydney time on the 28th Nov...
I have a number that when within a certain bracket needs to generate
the corresponding bonus ammount
if a consultant makes between $3000 and $3999 then the bonus is $50
If a consultant makes between $4000 and $4999 then the bonus is $75 and
so on
i need a formula to do that automatically
the bonus value ammount is in L16 so that would be where the formula is
and the total monthly sales is in L14

PLEASE HELP I only have 9 hrs

Try...

=LOOKUP(L14,{0,3000,4000,5000},{0,50,75,100})

Adjust the brackets and bonus amounts accordingly.

Hope this helps!

In article om,
wrote:

I have untill about 10am sydney time on the 28th Nov...
I have a number that when within a certain bracket needs to generate
the corresponding bonus ammount
if a consultant makes between $3000 and $3999 then the bonus is $50
If a consultant makes between $4000 and $4999 then the bonus is $75 and
so on
i need a formula to do that automatically
the bonus value ammount is in L16 so that would be where the formula is
and the total monthly sales is in L14

PLEASE HELP I only have 9 hrs

It's ok i've done it by nesting a huge number of IF and and statements.
If i hit limitations with that i'll leave something here

i didn't see your post before i replied, thanks I'll try it now

Thanks Domenic it worked a treat!

It's ok i've done it by nesting a huge number of IF

Another option:
[Bonus] =(Sales=3000)*(INT(Sales/1000)*25-25)

HTH
--
Dana DeLouis
Win XP & Office 2003


wrote in message
ups.com...
It's ok i've done it by nesting a huge number of IF and and statements.
If i hit limitations with that i'll leave something here