Excel if <> #NA
excel
Solution
Check below formula:
=IF(NOT(ISERROR(C70)),C70,IF(NOT(ISERROR(D70)),D70,IF(NOT(ISERROR(E70)),E70,IF(NOT(ISERROR(F70)),F70,"No Value"))))
Problem
To begin with I've tried searching the forum and can't find what I'm looking. I am trying to use the following formula: ``` =IF(C70<>"#NA",C70,IF(D70<>"#NA",D70,IF(E70<>"#NA",E70,IF(F70<>"#NA",F70,"No Value")))) ``` The formula is trying to combine 4 different columns with data in, only one of the cells would contain a value which is not #NA and I want to display that value in G70. Example Data Set: ``` C D E F 70 #N/A 30245_3 #N/A #N/A ``` The value will return only if in Column C, if any other column, it will return #NA. Any help appreciated!