Hello,

I'm new to post, but I've been reading this and many other excel forums for the last 6 months.

I am trying to create a function that will return whatever value is input as long as the value is not #DIV/0!
I don't want to use IFERROR because I still need to see if there are any reference or value errors, but I also don't want to see a bunch of #DIV/0!s all over the place.

This is what I've got so far but when I try to use it, it will result in a #VALUE! error unless the input value is #DIV/0!, in which case it returns 0...like I want it to.

Function IfDiv0(InputValue)
If InputValue = CVErr(xlErrDiv0) Then
IfDiv0 = 0
Else
IfDiv0 = InputValue
End If
End Function
Any help would be much appreciated.