Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hiding content when there is a #REF in a cell
Hi
I have a sheet that works out some stuff for me. it runs from Jan 2000 til Dec 2006. everything works out except for the cells in the future, like, Today through to Dec 2006 where the cell has #REF showing. I have a formula that is date related and so it throws up an error. how can I hide that content? regards |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
hiding content when there is a #REF in a cell
Something like:
=if(iserror(formula),"",formula) HTH "bobtracey" wrote: Hi I have a sheet that works out some stuff for me. it runs from Jan 2000 til Dec 2006. everything works out except for the cells in the future, like, Today through to Dec 2006 where the cell has #REF showing. I have a formula that is date related and so it throws up an error. how can I hide that content? regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
display a drop-down list based on the content of another cell | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
Numeric content in one cell ( implicit formula ) and the result in another one | Excel Discussion (Misc queries) | |||
Transferring cell content between workbooks using cell references | Excel Discussion (Misc queries) |