COUNT - Why no error message

[Paul Moles]

Sorry about that pasted the wrong formula:

Harlan Grove suggested

IF(COUNT(1/(LEN(VLOOKUP(E4,A1:C5,2,0))>3)),"here","not
employed here")

Which works great I just don't understand why it doesn't
produce an error message as it appears to divide by zero.

Thanks

Paul Moles

 

[JulieD]

Hi Paul

its a lot easier on everyone if you stay in the same thread ... pick one of
the response to your first (or maybe second) post and reply to that with
your new comments.

Cheers
JulieD

 

[Bob Umlas]

Enter =COUNT(1/0) and you'll see a 0. Even tho the 1/0 produces a #DIV/0!,
the COUNT function has no problem with that!
Bob Umlas
Excel MVP