{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["ISERROR Function","Using ISERROR Function","SUMPRODUCT and ISERROR Function","Printing Optional Message","Controlling Search Operation","VBA","IFERROR Vs ISERROR"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"ISERROR Function","index":0,"n_rows":21,"n_cols":18,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,3],[0,1,0,3],[3,1,3,6]]}
["                Excel ISERROR Function"]
[null,"Excel ISERROR Function"]
[]
[null,"Checks whether a value is an error and returns True or False."]
[null,"                               =ISERROR (value)"]
[]
[null,"Input","Formula","Output",">>>>>>>","Returns true as input cell contains #DIV/0! error."]
[null,{"$f":"25/0","v":{"$error":"#DIV/0!"}}," =ISERROR(B7)",{"$f":"ISERROR(B8)","v":true},">>>>>>>","Returns true as input cell contains #NAME? error."]
[null,{"$f":"sum","v":{"$error":"#NAME?"}}," =ISERROR(B8)",true,">>>>>>>","Returns true as input cell contains #NUM! error."]
[null,{"$f":"SQRT(-5)","v":{"$error":"#NUM!"}}," =ISERROR(B9)",true,">>>>>>>","Returns false as input cell doesn’t contains any error."]
[null,25," =ISERROR(B10)",false,">>>>>>>","Returns true as input cell contains #N/A error."]
[null,{"$f":"MATCH(N14,B9,1)","v":{"$error":"#N/A"}}," =ISERROR(B11)",true,">>>>>>>","Returns true as input cell contains #VALUE! error."]
[null,{"$f":"B11+R21","v":{"$error":"#VALUE!"}}," =ISERROR(B12)",true,">>>>>>>","Returns true as input cell contains #REF! error."]
[null,{"$f":"SUM(#REF!)","v":{"$error":"#REF!"}}," =ISERROR(B13)",true]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"gg"]

{"sheet":"Using ISERROR Function","index":1,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,1,0,4],[1,1,1,6]]}
["                        Finding Error Using ISERROR Function"]
[null,"Finding Error Using ISERROR Function"]
[]
[null,"ID","Name","Price","Quantity ","Unit Price","Error"]
[null,1122,"Apples",2500,25,{"$f":"D5/E5","v":100},{"$f":"ISERROR(F5)","v":false}]
[null,1133,"Eggplant",150,50,{"$f":"D6/E6","v":3},{"$f":"ISERROR(F6)","v":false}]
[null,1144,"White Potato ",500,60,8.3333333333333339,false]
[null,1155,"Grapes\t",4000,0,{"$error":"#DIV/0!"},true]
[null,1166,"Mango",2700,24,112.5,false]
[null,1177,"Butter ",600,13,46.153846153846153,false]
[null,1188,"Milk",5000,600,8.3333333333333339,false]
[null,1199,"Cheese",3500,0,{"$error":"#DIV/0!"},true]
[null,2200,"Orange",2600,80,32.5,false]
[null,2211,"Pineapple",450,10,45,false]
[null,2222,"Cauliflower",1200,100,12,false]
[null,2233,"Pineapple",2200,0,{"$f":"D16/E16","v":{"$error":"#DIV/0!"}},true]

{"sheet":"SUMPRODUCT and ISERROR Function","index":2,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6],[0,1,0,6]]}
["                  Calculating Total Error Using SUMPRODUCT and ISERROR Function"]
[null,"Calculating Total Error Using SUMPRODUCT and ISERROR Function"]
[]
[null,"ID","Name","Price","Quantity ","Unit Price","Error"]
[null,1122,"Apples",2500,25,{"$f":"D5/E5","v":100},{"$f":"ISERROR(F5)","v":false}]
[null,1133,"Eggplant",150,50,{"$f":"D6/E6","v":3},{"$f":"ISERROR(F6)","v":false}]
[null,1144,"White Potato ",500,60,8.3333333333333339,false]
[null,1155,"Grapes\t",4000,0,{"$error":"#DIV/0!"},true]
[null,1166,"Mango",2700,24,112.5,false]
[null,1177,"Butter ",600,0,{"$error":"#DIV/0!"},true]
[null,1188,"Milk",5000,600,8.3333333333333339,false]
[null,1199,"Cheese",3500,0,{"$error":"#DIV/0!"},true]
[]
[null,null,"Total Errors",{"$f":"SUMPRODUCT(--ISERROR(F5:F12))","v":3}]

{"sheet":"Printing Optional Message","index":3,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5],[0,1,0,5]]}
["                   Printing Optional Messages for Cells Containing Errors"]
[null,"Printing Optional Message for Cells Containing Errors"]
[]
[null,"ID","Name","Price","Quantity ","Unit Price"]
[null,1122,"Apples",2500,25,{"$f":"IF(ISERROR(D5/E5),\"Quantity not Found\",D5/E5)","v":100}]
[null,1133,"Eggplant",150,50,{"$f":"IF(ISERROR(D6/E6),\"Quantity not Found\",D6/E6)","v":3}]
[null,1144,"White Potato ",500,60,8.3333333333333339]
[null,1155,"Grapes\t",4000,0,"Quantity not Found"]
[null,1166,"Mango",2700,24,112.5]
[null,1177,"Butter ",600,13,46.153846153846153]
[null,1188,"Milk",5000,600,8.3333333333333339]
[null,1199,"Cheese",3500,0,"Quantity not Found"]
[null,2200,"Orange",2600,80,32.5]
[null,2211,"Pineapple",450,10,45]
[null,2222,"Cauliflower",1200,100,12]
[null,2233,"Pineapple",2200,0,"Quantity not Found"]

{"sheet":"Controlling Search Operation","index":4,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[0,2,0,5]]}
["                         Control Search Operation Using ISERROR Function"]
[null,"Controlling Search Operation Using ISERROR Function"]
[]
[null,"ID","Name","Price","Quantity ","Unit Price"]
[null,1122,"Apples",2500,25,{"$f":"IF(ISERROR(D5/E5),\"Quantity not Found\",D5/E5)","v":100}]
[null,1133,"Eggplant",150,50,{"$f":"IF(ISERROR(D6/E6),\"Quantity not Found\",D6/E6)","v":3}]
[null,1144,"White Potato ",500,60,8.3333333333333339]
[null,1155,"Grapes\t",4000,200,20]
[null,1166,"Mango",2700,24,112.5]
[null,1177,"Butter ",600,13,46.153846153846153]
[null,1188,"Milk",5000,600,8.3333333333333339]
[]
[null,null,"Enter ID",1155]
[null,null,"Name",{"$f":" IF( ISERROR( VLOOKUP( D13, CHOOSE( {1,2}, $B$5:$B$11, $C$5:$C$11 ), 2, 0) ),\n“Not available”, VLOOKUP( D13, CHOOSE( {1,2}, $B$5:$B$11, $C$5:$C$11 ), 2, 0) )","v":"Grapes\t"}]

{"sheet":"VBA","index":5,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[[3,1,3,2],[4,1,4,2],[1,1,1,2],[0,1,0,2]]}
["       ISERROR Function in VBA Code"]
[null,"ISERROR Function in VBA Code"]
[]
[null,"Enter the Value to Test"]
[null,{"$f":"5/0","v":{"$error":"#DIV/0!"}}]

{"sheet":"IFERROR Vs ISERROR","index":6,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"IFERROR Vs ISERROR Function"]
[]
[null,"Numerator","Denominator","Division (B5/C5)","IFERROR","ISERROR"]
[null,10,3,{"$f":"B5/C5","v":3.3333333333333335},{"$f":"IFERROR(D5,\"ERROR\")","v":3.3333333333333335},{"$f":"ISERROR(D5)","v":false}]
[null,5,0,{"$f":"B6/C6","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(D6,\"ERROR\")","v":"ERROR"},{"$f":"ISERROR(D6)","v":true}]
[null,6,4,1.5,1.5,false]
[null,8,2,4,4,false]
[null,20,0,{"$error":"#DIV/0!"},"ERROR",true]
[null,25,0,{"$error":"#DIV/0!"},"ERROR",true]