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?