how do i hide error codes [closed]
In calc, I'm building a very simple spreadsheet to calculate percentages of win/lose or draw results.
The forumla is simple: =(c3/e3) as an example, where c3 is the sum of column C and e3 is the sum of column e. Of course, we haven't started populating data yet (that will happen as the tournament progresses), so all of my fields that give me percentages show a divide by 0 error (#DIV/0!).
Is there a way to hide that error code until there is some valid data to process?
The sheet works fine, I just don't like having (#DIV/0!) all over the place.
(I'm also open to suggestions on how to streamline the process.)