If, and, or conditional formulas together
 

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

If, and, or conditional formulas together
 

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

If, and, or conditional formulas together
 

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

If, and, or conditional formulas together
 

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?
--
Chip


"Bob Phillips" wrote:

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

If, and, or conditional formulas together
 

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