# disrupts formula

I have two columns of data that I need to compare. The data is the result from an external report exported into excel, and one of the data pieces that gets returned in the report (third-party, can't change) is "#N/A". My formula doesn't work for cells where this data is compared. Example below:

Formula =OR(Data1="Passed",Data2="Passed")

Result Data1 Data2
True Passed Failed
True Started Passed
False Started Failed
#N/A Passed #N/A

Without editing the original data (which I know is an option but an extra, manual, repetitive step), how can I fix this and why is this happening?

Thanks!

Try wrapping your formula in an IFERROR function( or IF(ISERROR...) with pre 2003 versions

Hi,

another possible approach could be

=IF(COUNTIF(B2:C2,"passed"),"TRUE")

Hope that helps

This works! Thank you!

canapone said:

hi,

another possible approach could be

=if(countif(b2:c2,"passed"),"true")

hope that helps

Click to expand...

Hi,

thanks for providing feedback.

Ciao