Re: COUNT - Why no error message
From: Bob Umlas (rumlas_at_kpmg.com)
Date: 09/09/04
- Next message: Jay: "Re: - minus values needs to be corrected."
- Previous message: havocdragon: "Re: I need a formula that will look up and count specific instance"
- In reply to: Paul Moles: "COUNT - Why no error message"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 9 Sep 2004 10:35:25 -0400
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
"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
>
>
- Next message: Jay: "Re: - minus values needs to be corrected."
- Previous message: havocdragon: "Re: I need a formula that will look up and count specific instance"
- In reply to: Paul Moles: "COUNT - Why no error message"
- Messages sorted by: [ date ] [ thread ]
