Thread: DIsplay a value of the cell calculation is #N/A
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
JW[_2_] JW[_2_] is offline
external usenet poster
  
Posts: 638
Default DIsplay a value of the cell calculation is #N/A
On Oct 17, 5:56 pm, BZeyger wrote:
I have numerious calculations occuring in cells. Many times if certain values
cannot be calculted, #N/A appears. I would like the field to display "Null"
or "Nothing" if the error appears. How can this be done? I want a different
display instead of #N/A.

=IF(ISNA(yourCalculation),"",yourCalculation)
or
=IF(ISNA(yourCalculation),"Null",yourCalculation)

Reply With QuoteReply With Quote