I have very large spreadsheets with blank cells sprinkled here and there. Occasionally, a formula will refer to a blank cell and it returns the #NUM!, #DIV! or more importantly an actual number when one of the referenced cells is blank. Is there a box I can check in settings that will just give me a blank cell when a reference cell is empty? It would save me gagillions of hours and I would be eternally grateful if someone knows!
Bookmarks