{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["IF function","Combine Functions","Conditional Formatting","Excel 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":"IF function","index":0,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Use of IF Function",null,null,null,null,null,"Try Yourself"]
[]
[null,"Clients","Meeting Date","Alerts",null,null,null,"Clients","Meeting Date","Alerts"]
[null,"Andy Teal","2022-12-20",{"$f":"IF(C5=TODAY(),\"Today\",\"Due Later\")","v":"Today"},null,null,null,"Andy Teal","2022-12-19"]
[null,"Robert Walters","2022-12-21",{"$f":"IF(C6=TODAY(),\"Today\",\"Due Later\")","v":"Due Later"},null,null,null,"Robert Walters","2022-12-21"]
[null,"Susan W. Eaton","2022-12-25","Due Later",null,null,null,"Susan W. Eaton","2022-12-25"]
[null,"Kim Ralls","2022-12-30","Due Later",null,null,null,"Kim Ralls","2022-12-30"]
[null,"Kathie Flood","2023-01-01","Due Later",null,null,null,"Kathie Flood","2023-01-01"]

{"sheet":"Combine Functions","index":1,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Combination of IF, TODAY & AND Functions",null,null,null,null,null,"Try Yourself"]
[]
[null,"Clients","Meeting Date","Alerts",null,null,null,"Clients","Meeting Date","Alerts"]
[null,"Andy Teal","2022-12-20",{"$f":"IF(AND(C5<>\"\",TODAY()=C5),\"Today\",\"Due Later\")","v":"Today"},null,null,null,"Andy Teal","2022-12-19"]
[null,"Robert Walters","2022-12-21",{"$f":"IF(AND(C6<>\"\",TODAY()+0=C6),\"Today\",\"Due Later\")","v":"Due Later"},null,null,null,"Robert Walters","2022-12-21"]
[null,"Susan W. Eaton","2022-12-25","Due Later",null,null,null,"Susan W. Eaton","2022-12-25"]
[null,"Kim Ralls","2022-12-30","Due Later",null,null,null,"Kim Ralls","2022-12-30"]
[null,"Kathie Flood","2023-01-01","Due Later",null,null,null,"Kathie Flood","2023-01-01"]

{"sheet":"Conditional Formatting","index":2,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Use of Conditional Formatting",null,null,null,null,null,"Try Yourself"]
[]
[null,"Clients","Meeting Date","Alerts",null,null,null,"Clients","Meeting Date","Alerts"]
[null,"Andy Teal","2022-12-20",{"$f":"IF(AND(C5<>\"\",TODAY()=C5),\"Today\",\"Due Later\")","v":"Today"},null,null,null,"Andy Teal","2022-12-19"]
[null,"Robert Walters","2022-12-22",{"$f":"IF(AND(C6<>\"\",TODAY()=C6),\"Today\",\"Due Later\")","v":"Due Later"},null,null,null,"Robert Walters","2022-12-21"]
[null,"Susan W. Eaton","2022-12-25","Due Later",null,null,null,"Susan W. Eaton","2022-12-25"]
[null,"Kim Ralls","2022-12-29","Due Later",null,null,null,"Kim Ralls","2022-12-30"]
[null,"Kathie Flood","2023-01-01","Due Later",null,null,null,"Kathie Flood","2023-01-01"]

{"sheet":"Excel VBA","index":3,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Use of Excel VBA",null,null,null,null,"Try Yourself"]
[]
[null,"Clients","Meeting Date",null,null,null,"Clients","Meeting Date"]
[null,"Andy Teal","2022-12-19",null,null,null,"Andy Teal","2022-12-19"]
[null,"Robert Walters","2022-12-20",null,null,null,"Robert Walters","2022-12-21"]
[null,"Susan W. Eaton","2022-12-21",null,null,null,"Susan W. Eaton","2022-12-25"]
[null,"Kim Ralls","2022-12-22",null,null,null,"Kim Ralls","2022-12-30"]
[null,"Kathie Flood","2022-12-23",null,null,null,"Kathie Flood","2023-01-01"]