Not showing #DIV/0!
Not showing #DIV/0!
(OP)
I have a simple formula which sometimes produces a #DIV/0! when the divisor is zero.
I wanted to just show 0 or even -.
I tried this =IF(+D10/E10>0,D10/E10,0) but it still gave me #DIV/0!.
I am sure the answer is simple but I cannot think of it.
I wanted to just show 0 or even -.
I tried this =IF(+D10/E10>0,D10/E10,0) but it still gave me #DIV/0!.
I am sure the answer is simple but I cannot think of it.
Stephen Argles
Land & Marine
www.landandmarine.com





RE: Not showing #DIV/0!
Value is the argument that is checked for an error.
Value_if_error is the value to return if the formula evaluates to an error. The following error types are evaluated: #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!.
RE: Not showing #DIV/0!
Stephen Argles
Land & Marine
www.landandmarine.com
RE: Not showing #DIV/0!