#DIV/0! error - need help correcting against particular formula

[Nubian]

Hello again,

I have the DIV error. And I have the below formula. What do I need to add to return "0" instead of #DIV/0! please

=IF(ISERROR(VLOOKUP(A3,CtyHrs,3,FALSE)),0,VLOOKUP(A3,CtyHrs,3,FALSE))/K2

Cell K2 is hours and some of these cells contain "0" where i get the error.

Thanks for your patience

[Trebor76]

Hi Nubian,

You need to incorporate the divsion into the ISERROR section of the formula, i.e.:

=IF(ISERROR(VLOOKUP(A3,CtyHrs,3,FALSE)/K2),0,VLOOKUP(A3,CtyHrs,3,FALSE)/K2)

HTH

Robert

[shg]

Or =IF(N(K2), VLOOKUP(A3, CtyHrs, 3, FALSE)/K2, 0)

[Nubian]

Many thanks Robert, this solved it

[Nubian]

and thank you shg

[Trebor76]

Nubian,

Thanks for letting us know.

Please mark the thread as solved when you get a chance.

shg,

We must be on the same wave length or something!!

Regards,

Robert