Thread: #VALUE!
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Per Jessen[_2_] Per Jessen[_2_] is offline
external usenet poster
  
Posts: 703
Default #VALUE!
Hi

Try something like this:

=If(IsError(yourFormula),"",yourFormula)

Hopes this helps.
....
Per

On 11 Jan., 21:00, dwolf wrote:
Is there a way to hide the "#value!" so it does not show in the cell?

Reply With QuoteReply With Quote