Thread
:
Removing #N/A from formula results
View Single Post
#
9
Posted to microsoft.public.excel.worksheet.functions
Roger Govier[_11_]
external usenet poster
Posts: 18
Removing #N/A from formula results
If you have XL2007 or later, you could just wrap your formula in IFERROR()
=IFERROR(your formula,0)
Reply With Quote
Roger Govier[_11_]
View Public Profile
Find all posts by Roger Govier[_11_]
Removing #N/A from formula results