Thread: Hide #VALUE! from cells
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bondi
 
Posts: n/a
Default Hide #VALUE! from cells
Hi,

You can use:
=IF(ISERROR(YourReference),"",YourReference)

Regards,
Bondi

Reply With QuoteReply With Quote