Thread: validating references; how to recognize the #REF! condition
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
okey okey is offline
external usenet poster
  
Posts: 7
Default validating references; how to recognize the #REF! condition
#REF!

How do you generally intercept/recognize cell reference errors? Is
there a function you can wrap another function inside

I want to leave a value of 0 whenever a #REF! would occur.

Thank you.
Reply With QuoteReply With Quote