{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["main dataset","adjacent","return value","IF&ISBLANK","IF&COUNTBLANK","IF+COUNTIF","IF+SUMPRODUCT","IF+LEN","highlight blank cells","formula to highlight","SUMIF","countif","VBA","Practice"],"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":"main dataset","index":0,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"\"X\" Company"]
[]
[null,"Item","Order Date","Delivery Date","Sales"]
[null,"Shirt1","2021-11-25","2021-12-02",5979]
[null,"Pant1","2021-11-30",null,4559]
[null,"Jacket1","2021-12-01","2021-12-10",4588]
[null,"Shirt2","2021-11-25","2021-11-28",4196]
[null,"Pant2","2021-12-10",null,2436]
[null,"Jacket2","2021-12-08","2021-12-13",2425]
[null,"Shirt3","2021-12-12",null,5010]

{"sheet":"adjacent","index":1,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Returning Value of Adjacent Cells"]
[]
[null,"Item","Order \nDate","Delivery \nDate","Sales","Order Date for Not Delivered items"]
[null,"Shirt1","2021-11-25","2021-12-02",5979,{"$f":"IF(D5=\"\",C5,\"\")","v":""}]
[null,"Pant1","2021-11-30",null,4559,{"$f":"IF(D6=\"\",C6,\"\")","v":"2021-11-30"}]
[null,"Jacket1","2021-12-01","2021-12-10",4588,""]
[null,"Shirt2","2021-11-25","2021-11-28",4196,""]
[null,"Pant2","2021-12-10",null,2436,"2021-12-10"]
[null,"Jacket2","2021-12-08","2021-12-13",2425,""]
[null,"Shirt3","2021-12-12",null,5010,"2021-12-12"]

{"sheet":"return value","index":2,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using IF function to return a value"]
[]
[null,"Item","Order Date","Delivery Date","Sales","5% Off"]
[null,"Shirt1","2021-11-25","2021-12-02",5979,{"$f":"IF(D5=\"\",5%*E5,\"\")","v":""}]
[null,"Pant1","2021-11-30",null,4559,{"$f":"IF(D6=\"\",5%*E6,\"\")","v":227.95000000000002}]
[null,"Jacket1","2021-12-01","2021-12-10",4588,""]
[null,"Shirt2","2021-11-25","2021-11-28",4196,""]
[null,"Pant2","2021-12-10",null,2436,121.80000000000001]
[null,"Jacket2","2021-12-08","2021-12-13",2425,""]
[null,"Shirt3","2021-12-12",null,5010,250.5]

{"sheet":"IF&ISBLANK","index":3,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using IF function to return a value"]
[]
[null,"Item","Order\n Date","Delivery \nDate","Sales","Delivered/Not Delivered"]
[null,"Shirt1","2021-11-25","2021-12-02",5979,{"$f":"IF(ISBLANK(D5),\"Not Delivered\",\"Delivered\")","v":"Delivered"}]
[null,"Pant1","2021-11-30",null,4559,{"$f":"IF(ISBLANK(D6),\"Not Delivered\",\"Delivered\")","v":"Not Delivered"}]
[null,"Jacket1","2021-12-01","2021-12-10",4588,"Delivered"]
[null,"Shirt2","2021-11-25","2021-11-28",4196,"Delivered"]
[null,"Pant2","2021-12-10",null,2436,"Not Delivered"]
[null,"Jacket2","2021-12-08","2021-12-13",2425,"Delivered"]
[null,"Shirt3","2021-12-12",null,5010,"Not Delivered"]

{"sheet":"IF&COUNTBLANK","index":4,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"IF & COUNTBLANK Function"]
[]
[null,"Item","Order\n Date","Delivery \nDate","Delivered/Not Delivered"]
[null,"Shirt1","2021-11-25","2021-12-02",{"$f":"IF(COUNTBLANK(D5)>0,\"Not Delivered\",\"Delivered\")","v":"Delivered"}]
[null,"Pant1","2021-11-30",null,{"$f":"IF(COUNTBLANK(D6)>0,\"Not Delivered\",\"Delivered\")","v":"Not Delivered"}]
[null,"Jacket1","2021-12-01","2021-12-10","Delivered"]
[null,"Shirt2","2021-11-25","2021-11-28","Delivered"]
[null,"Pant2","2021-12-10",null,"Not Delivered"]
[null,"Jacket2","2021-12-08","2021-12-13","Delivered"]
[null,"Shirt3","2021-12-12",null,"Not Delivered"]

{"sheet":"IF+COUNTIF","index":5,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"IF & COUNTIF Function"]
[]
[null,"Item","Order\n Date","Delivery \nDate","Delivered/Not Delivered"]
[null,"Shirt1","2021-11-25","2021-12-02",{"$f":"IF(COUNTIF(D5,\"\")>0,\"Not Delivered\",\"Delivered\")","v":"Delivered"}]
[null,"Pant1","2021-11-30",null,{"$f":"IF(COUNTIF(D6,\"\")>0,\"Not Delivered\",\"Delivered\")","v":"Not Delivered"}]
[null,"Jacket1","2021-12-01","2021-12-10","Delivered"]
[null,"Shirt2","2021-11-25","2021-11-28","Delivered"]
[null,"Pant2","2021-12-10",null,"Not Delivered"]
[null,"Jacket2","2021-12-08","2021-12-13","Delivered"]
[null,"Shirt3","2021-12-12",null,"Not Delivered"]

{"sheet":"IF+SUMPRODUCT","index":6,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using IF+SUMPRODUCT function to return a value"]
[]
[null,"Item","Order\n Date","Delivery \nDate","Not Delivered Products"]
[null,"Shirt1","2021-11-25","2021-12-02",{"$f":"IF(SUMPRODUCT(--(D5=\"\"))>0,B5,\"\")","v":""}]
[null,"Pant1","2021-11-30",null,{"$f":"IF(SUMPRODUCT(--(D6=\"\"))>0,B6,\"\")","v":"Pant1"}]
[null,"Jacket1","2021-12-01","2021-12-10",""]
[null,"Shirt2","2021-11-25","2021-11-28",""]
[null,"Pant2","2021-12-10",null,"Pant2"]
[null,"Jacket2","2021-12-08","2021-12-13",""]
[null,"Shirt3","2021-12-12",null,"Shirt3"]

{"sheet":"IF+LEN","index":7,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using IF+LEN function to return a value"]
[]
[null,"Item","Order\n Date","Delivery \nDate","Not Delivered Products"]
[null,"Shirt1","2021-11-25","2021-12-02",{"$f":"IF(LEN(D5)=0,B5,\"\")","v":""}]
[null,"Pant1","2021-11-30",null,{"$f":"IF(LEN(D6)=0,B6,\"\")","v":"Pant1"}]
[null,"Jacket1","2021-12-01","2021-12-10",""]
[null,"Shirt2","2021-11-25","2021-11-28",""]
[null,"Pant2","2021-12-10",null,"Pant2"]
[null,"Jacket2","2021-12-08","2021-12-13",""]
[null,"Shirt3","2021-12-12",null,"Shirt3"]

{"sheet":"highlight blank cells","index":8,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Highlighting Blank Cells"]
[]
[null,"Item","Order Date","Delivery Date","Sales"]
[null,"Shirt1","2021-11-25","2021-12-02",5979]
[null,"Pant1","2021-11-30",null,4559]
[null,"Jacket1","2021-12-01","2021-12-10",4588]
[null,"Shirt2","2021-11-25","2021-11-28",4196]
[null,"Pant2","2021-12-10",null,2436]
[null,"Jacket2","2021-12-08","2021-12-13",2425]
[null,"Shirt3","2021-12-12",null,5010]

{"sheet":"formula to highlight","index":9,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Highlight Blank Cells with Formula"]
[]
[null,"Item","Order Date","Delivery Date","Sales"]
[null,"Shirt1","2021-11-25","2021-12-02",5979]
[null,"Pant1","2021-11-30",null,4559]
[null,"Jacket1","2021-12-01","2021-12-10",4588]
[null,"Shirt2","2021-11-25","2021-11-28",4196]
[null,"Pant2","2021-12-10",null,2436]
[null,"Jacket2","2021-12-08","2021-12-13",2425]
[null,"Shirt3","2021-12-12",null,5010]

{"sheet":"SUMIF","index":10,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[11,1,11,3]]}
[]
[null,"Using SUMIF function"]
[]
[null,"Item","Order Date","Delivery Date","Sales"]
[null,"Shirt1","2021-11-25","2021-12-02",5979]
[null,"Pant1","2021-11-30",null,4559]
[null,"Jacket1","2021-12-01","2021-12-10",4588]
[null,"Shirt2","2021-11-25","2021-11-28",4196]
[null,"Pant2","2021-12-10",null,2436]
[null,"Jacket2","2021-12-08","2021-12-13",2425]
[null,"Shirt3","2021-12-12",null,5010]
[null,"Sum of Sales for Not-Delivered Products",null,null,{"$f":"SUMIF(D5:D11,\"\",E5:E11)","v":12005}]

{"sheet":"countif","index":11,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[11,1,11,3]]}
[]
[null,"Using COUNTIF function"]
[]
[null,"Item","Order Date","Delivery Date","Sales"]
[null,"Shirt1","2021-11-25","2021-12-02",5979]
[null,"Pant1","2021-11-30",null,4559]
[null,"Jacket1","2021-12-01","2021-12-10",4588]
[null,"Shirt2","2021-11-25","2021-11-28",4196]
[null,"Pant2","2021-12-10",null,2436]
[null,"Jacket2","2021-12-08","2021-12-13",2425]
[null,"Shirt3","2021-12-12",null,5010]
[null,"Number of Not-Delivered Products",null,null,{"$f":"COUNTIF(D5:D11,\"\")","v":3}]

{"sheet":"VBA","index":12,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using VBA Code"]
[]
[null,"Item","Order\n Date","Delivery \nDate","Delivered/Not Delivered"]
[null,"Shirt1","2021-11-25","2021-12-02","Delivered"]
[null,"Pant1","2021-11-30",null,"Not Delivered"]
[null,"Jacket1","2021-12-01","2021-12-10","Delivered"]
[null,"Shirt2","2021-11-25","2021-11-28","Delivered"]
[null,"Pant2","2021-12-10",null,"Not Delivered"]
[null,"Jacket2","2021-12-08","2021-12-13","Delivered"]
[null,"Shirt3","2021-12-12",null,"Not Delivered"]

{"sheet":"Practice","index":13,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Practice"]
[]
[null,"Item","Order Date","Delivery Date","Sales"]
[null,"Shirt1","2021-11-25","2021-12-02",5979]
[null,"Pant1","2021-11-30",null,4559]
[null,"Jacket1","2021-12-01","2021-12-10",4588]
[null,"Shirt2","2021-11-25","2021-11-28",4196]
[null,"Pant2","2021-12-10",null,2436]
[null,"Jacket2","2021-12-08","2021-12-13",2425]
[null,"Shirt3","2021-12-12",null,5010]