Dear excel experts,
Formula is set in column F (F2:F5) to return "blank" or Block. No problem with that.
However, the data set has data which is #N/A.
Have problems in adding parameter if cell A to cell E is #N/A, the cell return "No data"
Thanks all
Formula is set in column F (F2:F5) to return "blank" or Block. No problem with that.
However, the data set has data which is #N/A.
Have problems in adding parameter if cell A to cell E is #N/A, the cell return "No data"
Book1 | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | A Count | B Count | C Count | D Count | E Block | PHONE BLOCK | ||
2 | 0 | 0 | 0 | 0 | N | Block | ||
3 | 0 | 0 | X | 0 | Y | Block | ||
4 | 0 | 0 | 0 | 0 | Y | |||
5 | 0 | 0 | 0 | 0 | Y | |||
6 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
F2:F5 | F2 | =IF(OR(COUNTIF(A2:E2,"X"),COUNTIF(A2:E2,"N")),"Block","") |
F6 | F6 | =IF(E6="#N/A",No Data," ") |
Thanks all