Thread: What does ISERROR look at besides the 7 Error Types?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Bob is offline
external usenet poster
  
Posts: 972
Default 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.
Reply With QuoteReply With Quote