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