Thread: Can I turn the #N/A result from a lookup function to a zero?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gaurav[_3_] Gaurav[_3_] is offline
external usenet poster
  
Posts: 127
Default Can I turn the #N/A result from a lookup function to a zero?
=IF(ISNA(your formula),0,your formula)


"mbpoet" wrote in message
...


"Chase" wrote:

Can I turn the #N/A result from a lookup function to a zero?

Thanks


Reply With QuoteReply With Quote