I don't have Excel here, to answer you with specifics, but the last time I ran into that I found out how to stop the "N/A" displaying by just looking in the Excel Help.
I believe it had to do with conditional formatting, and to tell the cell to display "" (nothing, as what is between the quotes) when the otherwise error condition exists.
Good luck, I am sure you can find it. If not then I suggest that you simply Google it. I did and found a few thousand hits.
Hi. I am trying to get excel to return the calculated average of cells in a row while excluding cells with #N/A value in the calculation. I do not want to end up with a returned value of #N/A because I have #N/A value cells in the row. My #N/A values are the result of a VLOOKUP function.
Could anyone suggest an approach? Thank you for your help on this.