not sure this is it but your description is confusing

OR(AND(A20,A2<20,B20,B2<A2*10%),AND(A2=20,A2<40 B2A2*15%),AND(A2=40,A2<90,B2A2*20%),AND(A2=90, B2A2*25%)

--
HTH

Bob

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

"Chipper" wrote in message
...
I need a formula which i beleive requires an IF And OR Statements together
but I am stuck.

It needs to say: if cell a is greater than 0 and less than 20, and cell b
is
greater than 0 than its cell b times 10% orif cell a is greater 20 and
less
than 40 and cell b is greater than 0, than its cell b times 15% or if cell
a
is greater than 40 but less than 90 and cell b is greater than 0 than its
cell b times 20% or if cell a is greater than 90 and cell b is greater
than 0
than its cell b times 25%
--
Chip