| Home |
| Search |
| Today's Posts |
|
#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!! |
| 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 | |||
Threaded Mode
