{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Title","OldWay","IFERROR","Recap"],"not_rendered":{"charts":0,"images":5,"macros":0,"external_links":1,"defined_names":17,"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":"Title","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,2042]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Image credit: sign/post/BD16DF06-48F2-4D22-BB67 / Pixabay"]

{"sheet":"OldWay","index":1,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Handle","Average"]
["Bluefeather8989",{"$f":"IF(ISNA(VLOOKUP(A2,Table,4,0)),\"Not Found\",VLOOKUP(A2,Table,4,0))","v":539},null,null,null,null,null,"Handle","Qty","Revenue","Avg Price"]
["MikeAsHimself",582,null,null,null,null,null,"aBoBoBook",895,521785,{"$f":"IFERROR(J3/I3,\"n.m.\")","v":583}]
["MrExcel",{"$error":"#DIV/0!"},null,null,null,null,null,"Bluefeather8989",989,533071,539]
["ExcelisFun","Not Found",null,null,null,null,null,"INDZARA",1124,611456,544]
["Bluefeather8989",539,null,null,null,null,null,"Kazmdav",1019,507462,498]
["McGunigales",527,null,null,null,null,null,"McGunigales",921,485367,527]
[null,null,null,null,null,null,null,"MikeAsHimself",843,490626,582]
[null,null,null,null,null,null,null,"MrExcel",0,0,{"$f":"J9/I9","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,"Symons",972,562788,579]

{"sheet":"IFERROR","index":2,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Handle","Average"]
["Bluefeather8989",{"$f":"IFERROR(VLOOKUP(A2,Table,4,0),\"Not Found\")","v":539},null,null,null,null,null,"Handle","Qty","Revenue","Avg Price"]
["MikeAsHimself",582,null,null,null,null,null,"aBoBoBook",895,521785,{"$f":"IFERROR(J3/I3,\"n.m.\")","v":583}]
["MrExcel","n.m.",null,null,null,null,null,"Bluefeather8989",989,533071,{"$f":"IFERROR(J4/I4,\"n.m.\")","v":539}]
["ExcelisFun","Not Found",null,null,null,null,null,"INDZARA",1124,611456,544]
["Bluefeather8989",539,null,null,null,null,null,"Kazmdav",1019,507462,498]
["McGunigales",527,null,null,null,null,null,"McGunigales",921,485367,527]
[null,null,null,null,null,null,null,"MikeAsHimself",843,490626,582]
[null,null,null,null,null,null,null,"MrExcel",0,0,"n.m."]
[null,null,null,null,null,null,null,"Symons",972,562788,579]

{"sheet":"Recap","index":3,"n_rows":7,"n_cols":13,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Episode Recap"]
[]
[null,"In the old days, you would use =IF(ISNA(Formula),0,Formula)"]
[null,"Starting in Excel 2010, =IFERROR(Formula,0)"]
[null,"But IFERROR treats DIV/0 errors the same was a #N/A! errors"]
[null,"Starting in Excel 2013, use the =IFNA(Formula,0) to detect only #N/A errors"]
[null,"Thanks to Justin Fishman, Stephen Gilmer, and Excel by Joe.",null,null,null,null,null,null,null,null,null,null,{"$f":"is","v":{"$error":"#NAME?"}}]