Thread
:
Display a "0" when #N/A appears in formula
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Duke Carey
Posts: n/a
Display a "0" when #N/A appears in formula
Try
=IF(ISNA(your formula),0,your formula)
"DarnTootn" wrote:
When working with a formula at returns a #N/A I would like it to display a
"0" instead
Reply With Quote
Display a "0" when #N/A appears in formula