Thread: Formula to convert resulting #N/A to 0
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
cehipso cehipso is offline
external usenet poster
  
Posts: 2
Default Formula to convert resulting #N/A to 0


"Jerry W. Lewis" wrote:

=IF(ISNA(formula),0,formula)

Jerry

"cehipso" wrote:
Thanks a lot to Jerry
Formulas using vlookup or similar returns #N/A if values are not found.
How can this string be converted to 0 other way than manually?
Reply With QuoteReply With Quote