Multiple If Then Statement based on ranges
 

I need a formula that says:

If A1 is between $x and $x, then Q1, or if A1 is between $x and $x, then Q2,
or if A1 is between $x and $x, then Q3, or if A1 is between $x and $x then Q4.

I've tried a bunch but they don't seem to work!!

Multiple If Then Statement based on ranges
 

=IF(AND(A1=B10,A1<=C10),Q1IF(AND(A1=B11,A1<=C11) ,Q2,IF(AND(A1=B12,A1<=C12
),Q1,"")))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

<Multiple If; "Then statements" <Multiple If, Then
wrote in message
...
I need a formula that says:

If A1 is between $x and $x, then Q1, or if A1 is between $x and $x, then
Q2,
or if A1 is between $x and $x, then Q3, or if A1 is between $x and $x then
Q4.

I've tried a bunch but they don't seem to work!!

Multiple If Then Statement based on ranges
 

=IF(A1<100,Q1,IF(A1<200,Q2,IF(A1<300,Q3,IF(A1<400, Q4,"another number"))))

Adjust to suit


"Multiple If, Then statements" wrote:

I need a formula that says:

If A1 is between $x and $x, then Q1, or if A1 is between $x and $x, then Q2,
or if A1 is between $x and $x, then Q3, or if A1 is between $x and $x then Q4.

I've tried a bunch but they don't seem to work!!

Multiple If Then Statement based on ranges
 

What if A1 is #N/A and you want it to kick back "" blank or 0?


"Teethless mama" wrote:

=IF(A1<100,Q1,IF(A1<200,Q2,IF(A1<300,Q3,IF(A1<400, Q4,"another number"))))

Adjust to suit


"Multiple If, Then statements" wrote:

I need a formula that says:

If A1 is between $x and $x, then Q1, or if A1 is between $x and $x, then Q2,
or if A1 is between $x and $x, then Q3, or if A1 is between $x and $x then Q4.

I've tried a bunch but they don't seem to work!!

Multiple If Then Statement based on ranges
 

=IF(ISNA(A1),"",IF(A1<100,Q1,IF(A1<200,Q2,IF(A1<30 0,Q3,IF(A1<400,Q4,"another
number")))))
--
David Biddulph

"Julie" wrote in message
...
What if A1 is #N/A and you want it to kick back "" blank or 0?


"Teethless mama" wrote:

=IF(A1<100,Q1,IF(A1<200,Q2,IF(A1<300,Q3,IF(A1<400, Q4,"another number"))))

Adjust to suit


"Multiple If, Then statements" wrote:

I need a formula that says:

If A1 is between $x and $x, then Q1, or if A1 is between $x and $x,
then Q2,
or if A1 is between $x and $x, then Q3, or if A1 is between $x and $x
then Q4.

I've tried a bunch but they don't seem to work!!

Multiple If Then Statement based on ranges
 

Just add another IF test:

For a return of blank:

=IF(ISNA(A1),"",IF(...........

For a return of 0:

=IF(ISNA(A1),0,IF(...........

--
Biff
Microsoft Excel MVP


"Julie" wrote in message
...
What if A1 is #N/A and you want it to kick back "" blank or 0?


"Teethless mama" wrote:

=IF(A1<100,Q1,IF(A1<200,Q2,IF(A1<300,Q3,IF(A1<400, Q4,"another number"))))

Adjust to suit


"Multiple If, Then statements" wrote:

I need a formula that says:

If A1 is between $x and $x, then Q1, or if A1 is between $x and $x,
then Q2,
or if A1 is between $x and $x, then Q3, or if A1 is between $x and $x
then Q4.

I've tried a bunch but they don't seem to work!!