Thread: how to put 0 instead of #n/a
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default how to put 0 instead of #n/a
=IF(ISNA(your formula),0,your formula

"Vas" wrote:

I am putting Lookup function.suppose if value is not there in table array.
it is giving #N/A. I want 0 instead of #N/A. How ? Pleae help me.

Regd.

Vas
Reply With QuoteReply With Quote