Thread: Display a "0" when #N/A appears in formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default Display a "0" when #N/A appears in formula
=IF(ISNA(formula),0,formula)


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"DarnTootn" wrote in message
...
When working with a formula at returns a #N/A I would like it to display a
"0" instead


Reply With QuoteReply With Quote