Hi Friends
Is there any formula where i can check in a specified range if contains any error #N/A, #ref!,#Div/0 etc etc.
=if(iserror(A1:P35),TRUE,FALSE), this formula doesnt work..
Thanks in advance
Hi Friends
Is there any formula where i can check in a specified range if contains any error #N/A, #ref!,#Div/0 etc etc.
=if(iserror(A1:P35),TRUE,FALSE), this formula doesnt work..
Thanks in advance
Hi.
=SUMPRODUCT(0+(ISERROR(A1:P35)))>0
Regards
hi anzafsa. try:
=SUMPRODUCT(--(ISERROR(A1:P35)))
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Both worked amazing..thanks a lot guys
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks