If, and, or conditional formulas together

[Chipper]

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%

 

[Bob Phillips]

not sure this is it but your description is confusing

OR(AND(A2>0,A2<20,B2>0,B2<A2*10%),AND(A2>=20,A2<40B2>A2*15%),AND(A2>=40,A2<90,B2>A2*20%),AND(A2>=90,B2>A2*25%)

--
HTH

Bob

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

 

[Roger Govier]

Hi Chip


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

=IF(AND(A1>0,A1<=20),A1*10%,
IF(AND(A1>20,A1<=40),A1*15%,
IF(AND(A1>40,A1<=90),A1*20%,
IF(A1>90,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(A1>90,A1*25%,
IF(A1>40,A1*20%,
IF(A1>20,A1*15%
IF(A1>0,A1*10%,"something else"))))

 

[Chipper]

I'll try to explain... the payout of some people depend revenue generated.

for example:

If a person's YTD revenue is 0-20,000 the rate is 10% but its 10% times the
mtd revenue. If a person's revenue is between 20,001 and 40,000 than the
rate is 15% but times the MTD revenue.. etc

Does that help the explaination?

 

[Chipper]

Hi-

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

Regards