Thread: HOW CAN I FIXED FORMULA THAT DISPLAYS #NA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier
 
Posts: n/a
Default HOW CAN I FIXED FORMULA THAT DISPLAYS #NA
Hi

try
=IF(ISNA(your_formula),"",your_formula)

--
Regards

Roger Govier


"mjb475" wrote in message
...



Reply With QuoteReply With Quote