View Single Post
  #1   Report Post  
Kathrine J Wathne
 
Posts: n/a
Default Excel - hide erroer values

Hi!
I have an Excel sheet were I have a few formulas. When the sheet is empty of
numbers the formula return the value #DIV/O!

I would like to know how I can hide this text - it does not look neat. I
want the formula to be there; but to show as empty. I have tried to use
conditional formatting which does hide the formula - but it then also hides
the result when I actually put numbers into the sheet.

Kathrine, Norway