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! |
#2
|
|||
|
|||
More than one ways of doing it , Use countif or vlookup or sumif etc
Here is one way On cell C1 type =IF(OR(A1=d1:d8)=TRUE,A1,0) array entered (Ctrl+shift+enter) "Turi" wrote in message ... 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! |
#3
|
|||
|
|||
In C1, try something like;
=--(COUNTIF($D$1:$D$8,A1)0)*B1 or =IF(COUNTIF($D$1:$D$8,A1)0,B1,0) "Turi" wrote in message ... 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! |
#4
|
|||
|
|||
Try this instead:
=IF(ISNA(MATCH(A1,D1:D8,0)),0,B1) HTH Jason Atlanta, GA -----Original Message----- 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! . |
Reply |
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 |