Thread: Is it possible to treat and display a #div/0 error as a zero?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Is it possible to treat and display a #div/0 error as a zero?
Maybe you meant:
=IF(ISERROR(<yourformula),0,<yourformula)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,400 Files:361 Subscribers:58
xdemechanik
---
"Andrew" wrote:
I have an output worksheet that relies partially on the the results of
formulas from linked worksheets. I want to be able provide users the option
of not inputing into every other linked worksheet, and thus treating any
#div/0 error as a simple zero value instead. Is there any way to do this
tools, etc?
Reply With QuoteReply With Quote