Hi-

and thanks to both of you!! I got myself confused as well, Roger, your
formulas were exavtly what I needed.

Regards
--
Chip


"Roger Govier" wrote:

Hi Chip


I'm also not sure that I understand fully your statements, but this might
help to get you started.

=IF(AND(A10,A1<=20),A1*10%,
IF(AND(A120,A1<=40),A1*15%,
IF(AND(A140,A1<=90),A1*20%,
IF(A190,A1*25%,"Something else"))))

Replace "Something Else" with what you want returned if none of the
conditions are met i.e if A1<0
This could also be written more easily as

=IF(A190,A1*25%,
IF(A140,A1*20%,
IF(A120,A1*15%
IF(A10,A1*10%,"something else"))))
--
Regards
Roger Govier

"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