Thread: Hiding #N/A
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jerry W. Lewis Jerry W. Lewis is offline
external usenet poster
  
Posts: 837
Default Hiding #N/A
=IF(ISNA(<formaula),"",<formula)

Jerry

jamie85 < wrote:

Is there a way that i can hide the #N/A that appers in a cell with a
lookup when there is no value in it? Thankyou.

Reply With QuoteReply With Quote