Thread: Can you make a cell = 0 if original function is creating a"#ref!"?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default Can you make a cell = 0 if original function is creating a"#ref!"?
If you don't want to make use of a separate cell (or column), you can
amend the formula which causes the #REF error as follows:

=IF(ISERROR(existing_formula),0,existing_formula)

Hope this helps.

Pete

Reply With QuoteReply With Quote