How to hide

[deanl33069]

I have a spread sheet with several formulas when the formula is not being used the cell displays #value ... how can i hide this till a value is added?

 

[Joe4]

Try wrapping the whole formula in an IFERROR function, i.e.

=IFERROR([I][COLOR=#ff0000]your formula here[/COLOR][/I],"")

So this tells it that if the formula returns an error, show nothing.