#N/A

[Solved/Closed]
Report
-
 New to excel too! -
Hi, can anyone help. I have an Excel spreadsheet with a "Final page" which has the accumulation of several other sheets and formulae in a table. For each column I have asked an IF(AND... formulae giving a result of "Y" or "", however due to the previous sheets and formulae some of the final page results are #N/A, hence when I ask the IF(AND..question it again gives an #N/A response.
My aim is to be able to examine the 4 column responses in a specific row and see if there are any "Y" responses in it.
At present because of the #N/A responses in some of the columns, even if there is a "Y" in a column the response is #N/A. Is there a way around this?

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
why not check if the value is an error ?

=IF(ISERROR(A1), "", A1)

Thanks Rizvisa1, have indeed wrapped my formulae into =IF(ISERROR(.... and successfully got rid of those #N/As to enable further analysis. Thanks for your help.