{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","ISTEXT AND IF","IF function","ISNUMBER and SEARCH","ISNUMBER & FIND","IF, ISERROR & FIND","IF and COUNTIF","IF and EXACT Funtion","VBA "],"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":"Dataset","index":0,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Sample Dataset"]
[]
[null,"Category"]
[null,"Bars"]
[null,"Crackers"]
[null,"Cookies"]
[null,"Cookies"]
[null,"Bars"]
[null,"Snacks"]
[null,"Snacks"]
[null,"Bars"]
[null,"Crackers"]

{"sheet":"ISTEXT AND IF","index":1,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of ISTEXT Function"]
[]
[null,"Category","Product"]
[null,"Bars",{"$f":"ISTEXT(B5)","v":true}]
[null,"Crackers",{"$f":"ISTEXT(B6)","v":true}]
[null,"Cookies",true]
[null,"Cookies",true]
[null,15120,false]
[null,"Snacks",true]
[null,1452,false]
[null,"Bars",true]
[null,125,false]

{"sheet":"IF function","index":2,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of IF Functions"]
[]
[null,"Category","Status"]
[null,"Bars",{"$f":"IF(B4=\"Bars\",\"True\",\"False\")","v":"False"}]
[null,"Crackers",{"$f":"IF(B5=\"Bars\",\"True\",\"False\")","v":"True"}]
[null,"Cookies","False"]
[null,"Cookies","False"]
[null,"Bars","False"]
[null,"Snacks","True"]
[null,"Snacks","False"]
[null,"Bars","False"]
[null,"Crackers","True"]

{"sheet":"ISNUMBER and SEARCH","index":3,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Combination of ISNUMBER and SEARCH Functions"]
[]
[null,"Category","Status"]
[null,"Bars",{"$f":"ISNUMBER(SEARCH(B5,\"Bars\"))","v":true}]
[null,"Crackers",false]
[null,"Cookies",false]
[null,"Cookies",false]
[null,"Bars",true]
[null,"Snacks",false]
[null,"Snacks",false]
[null,"Bars",true]
[null,"Crackers",false]

{"sheet":"ISNUMBER & FIND","index":4,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Combination of ISNNUMBER and FIND Functions"]
[]
[null,"Category","Product"]
[null,"Bars",{"$f":"ISNUMBER(FIND(B5,\"Bars\"))","v":true}]
[null,"Crackers",{"$f":"ISNUMBER(FIND(B6,\"Bars\"))","v":false}]
[null,"Cookies",false]
[null,"Cookies",false]
[null,"Bars",true]
[null,"Snacks",false]
[null,"Snacks",false]
[null,"Bars",true]
[null,"Crackers",false]

{"sheet":"IF, ISERROR & FIND","index":5,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Combination of IF, ISERROR, and FIND Functions"]
[]
[null,"Category","Product"]
[null,"Bars",{"$f":"IF(ISERROR(FIND(\"Bars\",B5,1)),\"False\",\"TRUE\")","v":"TRUE"}]
[null,"Crackers",{"$f":"IF(ISERROR(FIND(\"Bars\",B6,1)),\"False\",\"TRUE\")","v":"False"}]
[null,"Cookies","False"]
[null,"Cookies","False"]
[null,"Bars","TRUE"]
[null,"Snacks","False"]
[null,"Snacks","False"]
[null,"Bars","TRUE"]
[null,"Crackers","False"]

{"sheet":"IF and COUNTIF","index":6,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Combination of IF and COUNTIF Functions"]
[]
[null,"Category","Status"]
[null,"Bars",{"$f":"IF(COUNTIF(B5,\"*\"&\"Bars\"&\"*\"),\"True\",\"False\")","v":"True"}]
[null,"Crackers",{"$f":"IF(COUNTIF(B6,\"*\"&\"Bars\"&\"*\"),\"True\",\"False\")","v":"False"}]
[null,"Cookies","False"]
[null,"Cookies","False"]
[null,"Bars","True"]
[null,"Snacks","False"]
[null,"Snacks","False"]
[null,"Bars","True"]
[null,"Crackers","False"]

{"sheet":"IF and EXACT Funtion","index":7,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Combination of IF and EXACT Functions"]
[]
[null,"Category","Status"]
[null,"Bars",{"$f":"IF(EXACT(B5,\"Bars\"), \"True\", \"False\")","v":"True"}]
[null,"Crackers",{"$f":"IF(EXACT(B6,\"Bars\"), \"True\", \"False\")","v":"False"}]
[null,"Cookies","False"]
[null,"Cookies","False"]
[null,"Bars","True"]
[null,"Snacks","False"]
[null,"Snacks","False"]
[null,"Bars","True"]
[null,"Crackers","False"]

{"sheet":"VBA ","index":8,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Embedding VBA"]
[]
[null,"Text","Status"]
[null,"Bars",true]