New to excel too! - Jul 20, 2010 at 06:15 AM
 New to excel too! - Jul 21, 2010 at 08:25 AM
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 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
why not check if the value is an error ?

=IF(ISERROR(A1), "", A1)
New to excel too!
Jul 21, 2010 at 08:25 AM
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.