How to get rid of Div/0 in my formula

[baindes]

this formula gives me a Div/0 error. How can I add to this so when I divide and the end if gives me 0 or "" nothing? Thank you.

=IF(ISERROR(VLOOKUP($C8,Queries!$E$14:$F$105,2,FALSE)),0,VLOOKUP($C8,Queries!$E$14:$F$105,2,FALSE))/AB8

 

[Gerald Higgins]

Try this

=if(ab8=0,0,IF(ISERROR(VLOOKUP($C8,Queries!$E$14:$F$105,2,FAL SE)),0,VLOOKUP($C8,Queries!$E$14:$F$105,2,FALSE))/AB8)

<!-- / message -->

 

[Paella1]

mikerickson gave me this:

Function ShowNoError(unCorrected As Variant, Optional ShowIfError As Variant) As Variant
    If IsMissing(ShowIfError) Then ShowIfError = vbNullString
    If IsError(unCorrected) Then
        ShowNoError = ShowIfError
    Else
        ShowNoError = unCorrected
    End If
End Function

It's a function, so your put the whole forumal inside =shownoerror() and you will get a zero instead of #N/A. You can even amend the function to get fish & chips instead of zero, if you want to.

 

[Gerald Higgins]

Oh wow ! Never seen that scroll bar in a post - that wasn't deliberate on my part ! Anyone know how to remove it ?

 

[barry houdini]

Try

=IF(ISERROR(VLOOKUP($C8,Queries!$E$14:$F$105,2, FALSE)/AB8),0,VLOOKUP($C8,Queries!$E$14:$F$105,2,FALSE)/AB8)

 

[baindes]

Thanks to all. Just what I needed!