URGENT - Where do i start!

[jack.crombie]

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

 

[Domenic]

Try...

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

Adjust the brackets and bonus amounts accordingly.

Hope this helps!

 

[jack.crombie]

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

 

[jack.crombie]

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

 

[jack.crombie]

Thanks Domenic it worked a treat!

 

[Dana DeLouis]

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