hiding formula

[RDL]

Hi,
I am hoping some one can tell me how to hide answers from
a formula..kind of
I have created a report for others to use, so that all
they have to do is imput the numbers into the cells on the
computer (for example, no. of case for the month and no.
infected) and they will automatically get the infection
rate % as I have programed it in(the formula is =SUM
(E16/E15)). However, I can't seem to figure out how to
hide the "DIV/O!" that appears because no numbers have
been imputed in the cells yet(and wont be until the the
report is completed by someone else)

This is what part of the form looks like, minus the
gridlines

Total Last
This Month Last Month Yr/Date
No. Cases

No. Infected

Infected Rate % #DIV/0! #DIV/0! #DIV/0!


Thanks in advance

 

[Guest]

Use...
=IF(E15=0,"data incomplete",E16/E15)

 

[RDL]

Thanks, but is there a way to just leave the cell blank,
instead of it reading "data incomplete"?

 

[Guest]

Sure. say =IF(E15=0,"",E16/E15). I have found that
putting some words in sometimes helps the user to
understand why the cell shows no result. Just a thought.

 

[Gord Dibben]

Trap the error.

=IF(E15="","",E16/E15)

NOTE: the SUM function is not needed in your particular operation.

Gord Dibben Excel MVP