What does ISERROR look at besides the 7 Error Types?
Like what?
"Teethless mama" wrote:
ISERROR function is cover all kind the errors
"Bob" wrote:
I have a formula [=SUMPRODUCT(--(ISERROR(A2:CY5000)))] in my worksheet that
tells me that I have 24 "errors". After accounting for all the cells that
have either #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL! in them,
I'm still left with 8.
Can anyone tell me what the 8 other "errors" may be?
Thanks.
|