| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What does ISERROR look at besides the 7 Error Types?
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. |
Threaded Mode
