=E2*IF(F250,40%,IF(F240,35%,IF(F232,30%,IF(F22 8,25%,IF(F223,20%,0)))))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"jorgecarrejo" wrote in message
...
Ok, I am trying to create a formula that will do the following:

If cell F2 has any number between 23 and 28, I want it to multiply cell E2
by 20%,
if it has 28.01 and 32, then I want it to multiply cell E2 by 25%. If it
has
32.01- 40, then I want cell E2 to multiply by 30%. And so on.
I only want it to do 5 sets of this.

Can anybody help?
please email me at
Thanks,

Jorge