{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Basic error","Array Formula","VLOOKUP","VBA","LSI 1"],"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":"Basic error","index":0,"n_rows":10,"n_cols":15,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,10,1,14],[1,1,1,5]]}
[]
[null,"Eliminating Basic Error",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Product","Quantity","Total Cost","Ratio","Ratio (using IFERROR)",null,null,null,null,"Product","Quantity","Total Cost","Ratio","Ratio (using IFERROR)"]
[null,"Apple",30,90,{"$f":"D5/C5","v":3},{"$f":"IFERROR(E5,0)","v":3},null,null,null,null,"Apple",30,90]
[null,"Orange",0,0,{"$f":"D6/C6","v":{"$error":"#DIV/0!"}},{"$f":"IFERROR(E6,0)","v":0},null,null,null,null,"Orange",0,0,{"$f":"L6/M6","v":{"$error":"#DIV/0!"}}]
[null,"Lemon",25,50,2,2,null,null,null,null,"Lemon",25,50]
[null,"Avocado",28,56,2,2,null,null,null,null,"Avocado",28,56]
[null,"Raspberries",0,50,{"$error":"#DIV/0!"},0,null,null,null,null,"Raspberries",0,50]
[null,"Mango",50,100,2,2,null,null,null,null,"Mango",50,100]

{"sheet":"Array Formula","index":1,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,12]]}
[]
[null,"Using In Array Formula",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Product","Total Cost","Unit Price",null,"Total Quantity",null,null,"Product","Total Cost","Unit Price",null,"Total Quantity"]
[null,"Apple",90,1,null,{"$f":"SUM(C5:C10/D5:D10)","v":{"$error":"#DIV/0!"}},null,null,"Apple",90,1,null,{"$f":"SUM(J5:J10/K5:K10)","v":{"$error":"#DIV/0!"}}]
[null,"Orange",130,2,null,"Total Quantity Using IFERROR",null,null,"Orange",130,2,null,"Total Quantity Using IFERROR"]
[null,"Lemon",50,0.5,null,{"$f":"SUM(IFERROR(C5:C10/D5:D10,0))","v":294},null,null,"Lemon",50,0.5,null,{"$f":"SUM(IFERROR(J5:J10/K5:K10,0))","v":294}]
[null,"Avocado",56,4,null,null,null,null,"Avocado",56,4]
[null,"Raspberries",50,2,null,null,null,null,"Raspberries",50,2]
[null,"Mango",0,0,null,null,null,null,"Mango",0,0]

{"sheet":"VLOOKUP","index":2,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,9,1,13]]}
[]
[null,"Using with VLOOKUP",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Employee ID","Name","Salary",null,"Employee ID",null,null,null,"Employee ID","Name","Salary",null,"Employee ID"]
[null,"C001","John",3500,null,"C007",null,null,null,"C001","John",3500,null,"C001"]
[null,"C002","David",2300,null,"Salary",null,null,null,"C002","David",2300,null,"Salary"]
[null,"C003","William",2800,null,{"$f":"IFERROR(VLOOKUP(F5,B4:D10,3,0),\"ID Doesn't Exist\")","v":"ID Doesn't Exist"},null,null,null,"C003","William",2800,null,{"$f":"IFERROR(VLOOKUP(N5,J4:L10,3,0),\"ID Doesn't Exist\")","v":3500}]
[null,"C004","Sophia",3000,null,null,null,null,null,"C004","Sophia",3000]
[null,"C005","Emma",3800,null,null,null,null,null,"C005","Emma",3800]
[null,"C006","George",2400,null,null,null,null,null,"C006","George",2400]

{"sheet":"VBA","index":3,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,9,1,13]]}
[]
[null,"Using In VBA",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Employee ID","Name","Salary",null,"Employee ID",null,null,null,"Employee ID","Name","Salary",null,"Employee ID"]
[null,"C001","John",3500,null,"C007",null,null,null,"C001","John",3500,null,"C001"]
[null,"C002","David",2300,null,"Salary",null,null,null,"C002","David",2300,null,"Salary"]
[null,"C003","William",2800,null,{"$f":"IFERROR(VLOOKUP(F5,B4:D10,3,0),0)","v":0},null,null,null,"C003","William",2800,null,{"$f":"IFERROR(VLOOKUP(N5,J4:L10,3,0),\"ID Doesn't Exist\")","v":3500}]
[null,"C004","Sophia",3000,null,null,null,null,null,"C004","Sophia",3000]
[null,"C005","Emma",3800,null,null,null,null,null,"C005","Emma",3800]
[null,"C006","George",2400,null,null,null,null,null,"C006","George",2400]

{"sheet":"LSI 1","index":4,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,9,1,13]]}
[]
[null,"Returning Blank Instead of 0",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Employee ID","Name","Salary",null,"Employee ID",null,null,null,"Employee ID","Name","Salary",null,"Employee ID"]
[null,"C001","John",3500,null,"C008",null,null,null,"C001","John",3500,null,"C008"]
[null,"C002","David",2300,null,"Salary",null,null,null,"C002","David",2300,null,"Salary"]
[null,"C003","William",2800,null,{"$f":"IFERROR(VLOOKUP(F5,B4:D10,3,0),\"\")","v":""},null,null,null,"C003","William",2800,null,{"$f":"IFERROR(VLOOKUP(N5,J4:L10,3,0),\"\")","v":""}]
[null,"C004","Sophia",3000,null,null,null,null,null,"C004","Sophia",3000]
[null,"C005","Emma",3800,null,null,null,null,null,"C005","Emma",3800]
[null,"C006","George",2400,null,null,null,null,null,"C006","George",2400]