{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Contents","Introduction ISERROR","ISNA","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":[]}
["ISNA Function"]
[null,"automateexcel.com/functions/isna-formula-excel"]
[]
[null,"Table of Contents",null,null,null,"Other Resources"]
[null,"Introduction ISERROR",null,null,null,"Excel Formulas w/Examples"]
[null,"ISNA",null,null,null,"Excel Boot Camp - Learn Excel inside Excel"]
[null,"IFNA",null,null,null,"Excel Functions & Formulas Tutorial"]
[]
[]
[]
[]
[]
[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":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[4,5,4,6]]}
[]
[null,"ISNA",null,"=ISNA (value)"]
[null,"The Excel ISNA function returns TRUE when a cell contains the #N/A error."]
[]
[null,null,null,null,null,"Table 01"]
[null,"Name","VLOOKUP","Result_ISNA",null,"Name","DOB"]
[null,"Smith",{"$f":"VLOOKUP(B7,$F$6:$G$11,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"ISNA(VLOOKUP(B7,$F$6:$G$11,2,FALSE))","v":true},null,"Jonathon","1987-02-23"]
[null,"John",{"$f":"VLOOKUP(B8,$F$6:$G$11,2,FALSE)","v":"1985-01-24"},{"$f":"ISNA(VLOOKUP(B8,$F$6:$G$11,2,FALSE))","v":false},null,"Mike","1985-02-05"]
[null,"Mike","1985-02-05",false,null,"John","1985-01-24"]
[null,"Serina",{"$error":"#N/A"},true,null,"Jeremy","1984-11-21"]
[null,"Jonathon","1987-02-23",false,null,"William","1985-02-21"]
[]
[null,"automateexcel.com/functions/isna-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

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

{"sheet":"IFNA","index":3,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,4,0,5]]}
["Name","ISNA","Result_IFNA",null,"Table 01"]
["Smith",{"$f":"ISNA(VLOOKUP(A2,$E$2:$F$7,2,FALSE))","v":true},{"$f":"_xlfn.IFNA(VLOOKUP(A2,$E$2:$F$7,2,FALSE),\"No Data\")","v":"No Data"},null,"Name","DOB"]
["John",false,{"$f":"_xlfn.IFNA(VLOOKUP(A3,$E$2:$F$7,2,FALSE),\"No Data\")","v":"1985-01-24"},null,"Jonathon","1987-02-23"]
["Mike",false,"1985-02-05",null,"Mike","1985-02-05"]
["Serina",true,"No Data",null,"JOHN","1985-01-24"]
["Jonathon",false,"1987-02-23",null,"Jeremy","1984-11-21"]
[null,null,null,null,"William","1985-02-21"]
[]
[null,"automateexcel.com/functions/isna-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]