Ask Your Question
0

how do i hide error codes [closed]

asked 2014-06-24 23:14:56 +0100

chris.rebman.7 gravatar image

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.)

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-26 09:55:55.242839

1 Answer

Sort by » oldest newest most voted
1

answered 2014-06-24 23:27:14 +0100

Lupp gravatar image

We needn't hide the error code but care for the exception. The first suggestion should work in any case, the second one if the function IFERROR() is provided (versions 4.x and higher).

=IF(E3=0;"";C3/E3)

=IFERROR(C3/E3;"")

The empty string may, of course, be replaced by something else, best NA() .

edit flag offensive delete link more

Comments

1

Thank you. That works like a charm. Now to go edit all of the appropriate fields...=)

chris.rebman.7 gravatar imagechris.rebman.7 ( 2014-06-24 23:40:50 +0100 )edit

Question Tools

2 followers

Stats

Asked: 2014-06-24 23:14:56 +0100

Seen: 2,901 times

Last updated: Jun 24 '14