Re: COUNT - Why no error message

From: JulieD (JulieD_at_hctsReMoVeThIs.net.au)
Date: 09/09/04 

Date: Thu, 9 Sep 2004 21:44:56 +0800

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

"Paul Moles" <anonymous@discussions.microsoft.com> wrote in message
news:8ce801c4966f$f1929bf0$a501280a@phx.gbl...
> 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
>
>