Another quick question for everyone. I am trying to format cell A1 to be blank when data has not been entered in A2 or A3. I have to use the IFERROR function in A1 because this cell is used in an average elsewhere in the spreadsheet. Therefore, it cannot be a hidden error value or the average function will not operate properly. I have attached an example.
Any suggestions?
Book1.xlsx
Bookmarks