Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Kathrine,
Did you use a formula in CF, such as =ISERROR(A1) You could also change your formula to =IF(ISERROR(the_formula),"", the_formula) -- HTH RP (remove nothere from the email address if mailing direct) "Kathrine J Wathne" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Missing values in Excel Line Chart | Charts and Charting in Excel | |||
Formula for Searching & matching two values in excel | Excel Discussion (Misc queries) | |||
display negative values as a blank cell in Excel | Excel Discussion (Misc queries) | |||
display negative values as a blank cell in Excel | Excel Discussion (Misc queries) |