Thread: Cell has a value of #N/A when the formula refers to nothing
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Man Utd Man Utd is offline
external usenet poster
  
Posts: 23
Default Cell has a value of #N/A when the formula refers to nothing
I got a cell has a formula refering to a cell, say =2*A5, however, if the
referred cell(A5) is empty, this referring cell will display a string
"#N/A".
How do I display this referring cell empty rather than "#N/A" if the cell A5
is empty?


Reply With QuoteReply With Quote