| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
7+ nested if statement?
I currently have created an if statement with 7 nested if statements. I now
need to add another if statement, but there is a limit of 7 nested statements. Is there a work around. My issue is that I want to copy the # in cell B1 to cell C1 only if cell A1 matches one of the 8 values in column D (D1:D8), if not return a value of 0. The if statement worked for 7 values, but now I have 8. Please help Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mini-editor for nested IF's in Excel | Excel Discussion (Misc queries) | |||
| IF Statement with Average Function results in #Value! | Excel Discussion (Misc queries) | |||
| Combining SUM Function with Nested If Statement | Excel Discussion (Misc queries) | |||
| Statement | Excel Worksheet Functions | |||
| IF Statement difficulty | Excel Worksheet Functions | |||
Threaded Mode
