Not showing #DIV/0! 2

[StephenA]

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.

Stephen Argles
Land & Marine

http://www.landandmarine.com

 

[Clyde38]

IFERROR(value,value_if_error)

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!.

 

[StephenA]

Thanks Clyde38, just what I needed

Stephen Argles
Land & Marine

http://www.landandmarine.com

 

[rb1957]

or nest in if(e10=0,"na", ...)