Thread: Divide By 0
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Anders S[_2_] Anders S[_2_] is offline
external usenet poster
 
Posts: 57
Default Divide By 0

Mike,

In addition to the other two answers so far:

If you just want that "the error will not be displayed", you can use Conditional Formatting with a formula like =ISERROR(A1) and format for white text if the condition is true. The error will still be there, but it will not show.

Regards
Anders Silven

"Mike Short" skrev i meddelandet ...
The workbook I inherited contains many cells that are
vulnerable to divide by zero errors. Is there any "global"
fix so if the divisor is zero the error will not be
displayed?

Thank you