#N/A
Solved/Closed
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?
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 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jul 20, 2010 at 07:17 AM
Jul 20, 2010 at 07:17 AM
why not check if the value is an error ?
=IF(ISERROR(A1), "", A1)
=IF(ISERROR(A1), "", A1)
Jul 21, 2010 at 08:25 AM