| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Multiple, Noncontiguous Ranges in COUNTIF? | Excel Discussion (Misc queries) | |||
| How do I Select Multiple Non Adjacent Rows based on a cell value? | Excel Worksheet Functions | |||
| Multiple Ranges in 1 Column using VBA | Excel Discussion (Misc queries) | |||
| Printing multiple ranges on one worksheet | Excel Discussion (Misc queries) | |||
| compare unique identifiers in multiple ranges | Charts and Charting in Excel | |||
Linear Mode
