{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Contents","Introduction ISERROR","ISERROR","IF-ISerror","IFerror","ISERROR-VLOOKUP","ISERROR-VLOOKUP-IFNA"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"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":"Contents","index":0,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["ISERROR Function"]
[null,"automateexcel.com/functions/iserror-formula-excel"]
[]
[null,"Table of Contents",null,null,null,"Other Resources"]
[null,"Introduction ISERROR",null,null,null,"Excel Formulas w/Examples"]
[null,"ISERROR",null,null,null,"Excel Boot Camp - Learn Excel inside Excel"]
[null,"IF-ISerror",null,null,null,"Excel Functions & Formulas Tutorial"]
[null,"IFerror"]
[null,"ISERROR-VLOOKUP"]
[null,"ISERROR-VLOOKUP-IFNA"]
[]
[]
[null,"Excel Boot Camp"]
[null,"  Learn Excel Inside Excel"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"           Learn Excel inside Excel with our Interactive Tutorial"]
[null,"           Automatically Graded Exercises"]
[null,"           Shortcuts & Best Practices \"Work Smarter, not Harder\""]
[]
[]
[]
[]
[]
[]
[]
[null,"Course Contents"]

{"sheet":"Introduction ISERROR","index":1,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ISERROR",null,"=ISERROR(value)"]
[null,"The Excel ISERROR function returns TRUE for any error type excel generates."]
[]
[null,"Data","Result","Content_Column A"]
[null,12345,{"$f":"ISERROR(B6)","v":false},{"$f":"IF(_xlfn.ISFORMULA(B6),_xlfn.FORMULATEXT(B6),B6)","v":12345}]
[null,{"$f":"1/0","v":{"$error":"#DIV/0!"}},{"$f":"ISERROR(B7)","v":true},{"$f":"IF(_xlfn.ISFORMULA(B7),_xlfn.FORMULATEXT(B7),B7)","v":"=1/0"}]
[null,{"$f":"ABC","v":{"$error":"#NAME?"}},{"$f":"ISERROR(B8)","v":true},{"$f":"IF(_xlfn.ISFORMULA(B8),_xlfn.FORMULATEXT(B8),B8)","v":"=ABC"}]
[null,{"$f":"VLOOKUP(E6,F6:I13,2,FALSE)","v":{"$error":"#N/A"}},true,"=VLOOKUP(E6,F6:I13,2,FALSE)"]
[null,{"$f":"[1]Sheet1!#REF!","v":{"$error":"#REF!"}},{"$f":"ISERROR(B10)","v":true},{"$f":"IF(_xlfn.ISFORMULA(B10),_xlfn.FORMULATEXT(B10),B10)","v":"=Sheet1!#REF!"}]
[null,{"$f":"SQRT(-1)","v":{"$error":"#NUM!"}},{"$f":"ISERROR(B11)","v":true},{"$f":"IF(_xlfn.ISFORMULA(B11),_xlfn.FORMULATEXT(B11),B11)","v":"=SQRT(-1)"}]
[null,{"$f":"1+C5","v":{"$error":"#VALUE!"}},{"$f":"ISERROR(B12)","v":true},{"$f":"IF(_xlfn.ISFORMULA(B12),_xlfn.FORMULATEXT(B12),B12)","v":"=1+C5"}]
[]
[null,"automateexcel.com/functions/iserror-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"ISERROR","index":2,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Data","Result","Content_Column A"]
[{"$f":"1/0","v":{"$error":"#DIV/0!"}},{"$f":"ISERROR(A2)","v":true},{"$f":"IF(_xlfn.ISFORMULA(A2),_xlfn.FORMULATEXT(A2),A2)","v":"=1/0"}]
[{"$f":"ABC","v":{"$error":"#NAME?"}},{"$f":"ISERROR(A3)","v":true},{"$f":"IF(_xlfn.ISFORMULA(A3),_xlfn.FORMULATEXT(A3),A3)","v":"=ABC"}]
[{"$f":"VLOOKUP(D2,E2:H9,2,FALSE)","v":{"$error":"#N/A"}},true,"=VLOOKUP(D2,E2:H9,2,FALSE)"]
[{"$f":"[1]Sheet1!#REF!","v":{"$error":"#REF!"}},{"$f":"ISERROR(A5)","v":true},{"$f":"IF(_xlfn.ISFORMULA(A5),_xlfn.FORMULATEXT(A5),A5)","v":"=Sheet1!#REF!"}]
[{"$f":"SQRT(-1)","v":{"$error":"#NUM!"}},{"$f":"ISERROR(A6)","v":true},{"$f":"IF(_xlfn.ISFORMULA(A6),_xlfn.FORMULATEXT(A6),A6)","v":"=SQRT(-1)"}]
[{"$f":"1+A1","v":{"$error":"#VALUE!"}},{"$f":"ISERROR(A7)","v":true},{"$f":"IF(_xlfn.ISFORMULA(A7),_xlfn.FORMULATEXT(A7),A7)","v":"=1+A1"}]
[]
[null,"automateexcel.com/functions/iserror-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"IF-ISerror","index":3,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Item","Stock (KG)","Sell  (KG)","Sell %"]
["Oranges",0,0,{"$f":"IF(ISERROR(C2/B2),\"Zero Stock\",C2/B2)","v":"Zero Stock"}]
["Apples",150,150,{"$f":"IF(ISERROR(C3/B3),\"Zero Stock\",C3/B3)","v":1}]
["Pineapples",0,0,"Zero Stock"]
["Grapes",200,150,0.75]
["Banana",300,25,8.3333333333333329E-2]
["Papaya",275,0,0]
[]
[null,"automateexcel.com/functions/iserror-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"IFerror","index":4,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Item","Stock (KG)","Sell  (KG)","Sell%_IF_ISError","Sell% _IFError"]
["Oranges",0,0,{"$f":"IF(ISERROR(C2/B2),\"Zero Stock\",C2/B2)","v":"Zero Stock"},{"$f":"IFERROR((C2/B2),\"Zero Stock\")","v":"Zero Stock"},null,"=IFERROR((C2/B2),\"Zero Stock\")"]
["Apples",150,150,1,{"$f":"IFERROR((C3/B3),\"Zero Stock\")","v":1}]
["Pineapples",0,0,"Zero Stock","Zero Stock"]
["Grapes",200,150,0.75,0.75]
["Banana",300,25,8.3333333333333329E-2,8.3333333333333329E-2]
["Papaya",275,0,0,0]
[]
[null,"automateexcel.com/functions/iserror-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"ISERROR-VLOOKUP","index":5,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,3,0,4],[0,6,0,7]]}
["Name","DOB",null,"Table 01",null,null,"Table 02"]
["Smith",{"$f":"VLOOKUP(A2,$D$2:$E$7,2,FALSE)","v":{"$error":"#N/A"}},null,"Name","DOB",null,"Name","DOB"]
["John",{"$f":"VLOOKUP(A3,$D$2:$E$7,2,FALSE)","v":"1985-01-24"},null,"Jonathon","1987-02-23",null,"Serina","1987-02-23"]
["Mike","1985-02-05",null,"Mike","1985-02-05",null,"Serina","1985-02-05"]
["Serina",{"$error":"#N/A"},null,"JOHN","1985-01-24",null,"Marcus","1985-01-24"]
["Jonathon","1987-02-23",null,"Jeremy","1984-11-21",null,"Helen","1984-11-21"]
[null,null,null,"William","1985-02-21",null,"Smith","1985-02-21"]
[]
[null,"automateexcel.com/functions/iserror-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"ISERROR-VLOOKUP-IFNA","index":6,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,3,0,4],[0,6,0,7]]}
["Name","DOB",null,"Table 01",null,null,"Table 02"]
["Smith",{"$f":"_xlfn.IFNA(VLOOKUP(A2,$D$2:$E$7,2,FALSE),VLOOKUP(A2,$G$2:$H$7,2,FALSE))","v":"1985-02-21"},null,"Name","DOB",null,"Name","DOB"]
["John",{"$f":"_xlfn.IFNA(VLOOKUP(A3,$D$2:$E$7,2,FALSE),VLOOKUP(A3,$G$2:$H$7,2,FALSE))","v":"1985-01-24"},null,"Jonathon","1987-02-23",null,"Serina","1984-02-23"]
["Mike","1985-02-05",null,"Mike","1985-02-05",null,"Greg","1985-02-05"]
["Serina","1984-02-23",null,"JOHN","1985-01-24",null,"Marcus","1985-01-24"]
["Jonathon","1987-02-23",null,"Jeremy","1984-11-21",null,"Helen","1984-11-21"]
[null,null,null,"William","1985-02-21",null,"Smith","1985-02-21"]
[]
[null,"automateexcel.com/functions/iserror-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]