{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","IF &  AND ","Greater than & Less than","With Calculation","Multiple","Nested","IF-And two","Three conditions","Dataset (2)"],"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":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Sales Record"]
[]
[null,"Region","Quantity","Cost","Revenue","Profit"]
[null,"Asia",35,27475,29000,{"$f":"E5-D5","v":1525}]
[null,"Europe",54,355428,356890,{"$f":"E6-D6","v":1462}]
[null,"Africa",45,7020,7500,480]
[null,"North America",73,9500,10000,500]
[null,"Africa",85,3825,4825,1000]
[null,"Asia",15,4265,5500,1235]
[null,"Africa",95,24130,32520,8390]
[null,"Europe",82,21730,23000,1270]
[null,"Asia",25,625,725,100]

{"sheet":"IF &  AND ","index":1,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Using IF with AND Function for Blanks"]
[]
[null,"Region","Quantity","Cost","Revenue","Profit","Comment"]
[null,"Asia",35,27475,29000,{"$f":"E5-D5","v":1525},{"$f":"IF(AND(B5=\"Asia\",C5<>\"\"), \"PASSED\",\"DISQUALIFIED\")","v":"PASSED"}]
[null,"Europe",54,355428,356890,{"$f":"E6-D6","v":1462},{"$f":"IF(AND(B6=\"Asia\",C6<>\"\"), \"PASSED\",\"DISQUALIFIED\")","v":"DISQUALIFIED"}]
[null,"Africa",45,7020,7500,480,"DISQUALIFIED"]
[null,"North America",73,9500,10000,500,"DISQUALIFIED"]
[null,"Africa",85,3825,4825,1000,"DISQUALIFIED"]
[null,"Asia",null,4265,5500,1235,"DISQUALIFIED"]
[null,"Africa",95,24130,32520,8390,"DISQUALIFIED"]
[null,"Europe",82,21730,23000,1270,"DISQUALIFIED"]
[null,"Asia",25,625,725,100,"PASSED"]

{"sheet":"Greater than & Less than","index":2,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"IF-AND Formula with 'Greater Than' and 'Less Than' Operator"]
[]
[null,"Region","Quantity","Cost","Revenue","Profit","Comment"]
[null,"Asia",35,27475,29000,{"$f":"E5-D5","v":1525},{"$f":"IF(AND(F5>1200,C5<70), \"PASSED\",\"DISQUALIFIED\")","v":"PASSED"}]
[null,"Europe",54,355428,356890,{"$f":"E6-D6","v":1462},{"$f":"IF(AND(F6>1200,C6<70), \"PASSED\",\"DISQUALIFIED\")","v":"PASSED"}]
[null,"Africa",45,7020,7500,480,"DISQUALIFIED"]
[null,"North America",73,9500,10000,500,"DISQUALIFIED"]
[null,"Africa",85,3825,4825,1000,"DISQUALIFIED"]
[null,"Asia",15,4265,5500,1235,"PASSED"]
[null,"Africa",95,24130,32520,8390,"DISQUALIFIED"]
[null,"Europe",62,21730,23000,1270,"PASSED"]
[null,"Asia",25,625,725,100,"DISQUALIFIED"]

{"sheet":"With Calculation","index":3,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Calculating Commission Combining IF with AND Function"]
[]
[null,"Region","Quantity","Cost","Revenue","Profit","Commission"]
[null,"Asia",35,27475,29000,{"$f":"E5-D5","v":1525},{"$f":"IF(AND(F5>1200,C5<70),F5*10%,\"No Commission\")","v":152.5}]
[null,"Europe",54,355428,356890,{"$f":"E6-D6","v":1462},{"$f":"IF(AND(F6>1200,C6<70),F6*10%,\"No Commission\")","v":146.20000000000002}]
[null,"Africa",45,7020,7500,480,"No Commission"]
[null,"North America",73,9500,10000,500,"No Commission"]
[null,"Africa",85,3825,4825,1000,"No Commission"]
[null,"Asia",15,4265,5500,1235,123.5]
[null,"Africa",95,24130,32520,8390,"No Commission"]
[null,"Europe",62,21730,23000,1270,127]
[null,"Asia",25,625,725,100,"No Commission"]

{"sheet":"Multiple","index":4,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"IF-AND Formula with Multiple Conditions "]
[]
[null,"Region","Quantity","Cost","Revenue","Profit","Comment"]
[null,"Asia",35,27475,29000,{"$f":"E5-D5","v":1525},{"$f":"IF(AND(B5=\"Asia\",C5<>\"\",F5>1200), \"PASSED\",\"DISQUALIFIED\")","v":"PASSED"}]
[null,"Europe",54,355428,356890,{"$f":"E6-D6","v":1462},{"$f":"IF(AND(B6=\"Asia\",C6<>\"\",F6>1200), \"PASSED\",\"DISQUALIFIED\")","v":"DISQUALIFIED"}]
[null,"Africa",45,7020,7500,480,"DISQUALIFIED"]
[null,"North America",73,9500,10000,500,"DISQUALIFIED"]
[null,"Africa",85,3825,4825,1000,"DISQUALIFIED"]
[null,"Asia",15,4265,5500,1235,"PASSED"]
[null,"Africa",95,24130,32520,8390,"DISQUALIFIED"]
[null,"Europe",82,21730,23000,1270,"DISQUALIFIED"]
[null,"Asia",25,625,725,100,"DISQUALIFIED"]

{"sheet":"Nested","index":5,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Using Nested IF-AND Formula"]
[]
[null,"Region","Quantity","Cost","Revenue","Profit","Comment"]
[null,"Asia",35,27475,29000,{"$f":"E5-D5","v":1525},{"$f":"IF(AND(B5=\"Asia\",C5<>\"\"),\"PASSED\",IF(AND(B5<>\"Asia\",C5>50),\"Average\",\"DISQUALIFIED\"))","v":"PASSED"}]
[null,"Europe",54,355428,356890,{"$f":"E6-D6","v":1462},{"$f":"IF(AND(B6=\"Asia\",C6<>\"\"),\"PASSED\",IF(AND(B6<>\"Asia\",C6>50),\"Average\",\"DISQUALIFIED\"))","v":"Average"}]
[null,"Africa",45,7020,7500,480,"DISQUALIFIED"]
[null,"North America",73,9500,10000,500,"Average"]
[null,"Africa",85,3825,4825,1000,"Average"]
[null,"Asia",15,4265,5500,1235,"PASSED"]
[null,"Africa",95,24130,32520,8390,"Average"]
[null,"Europe",82,21730,23000,1270,"Average"]
[null,"Asia",25,625,725,100,"PASSED"]

{"sheet":"IF-And two","index":6,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Combining If with And for Two Conditions"]
[]
[null,"ID","Amount","Status","Discount"]
[null,1001,500,"VIP","10% Discount"]
[null,1123,200,"Regular","No Discount"]
[null,1342,550,"Regular","No Discount"]
[null,1235,200,"VIP","No Discount"]
[null,1355,600,"VIP","10% Discount"]
[]
[]
[null,null,null,null,null,"`"]

{"sheet":"Three conditions","index":7,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Utilizing More Than Two Conditions in Excel VBA"]
[]
[null,"Name","Joining Date","Age","Current Salary","Increment"]
[null,"Aaron","2019-03-18",32,4000,0.1]
[null,"Stacy","2020-09-01",27,3700,5.5E-2]
[null,"Jason","2022-08-01",39,4500,5.5E-2]
[null,"Jesicca","2016-01-01",33,4300,0.1]
[null,"Max","2019-06-01",31,5200,5.5E-2]
[null,"Tom","2021-10-01",29,2700,5.5E-2]
[null,"Micheal","2017-02-01",35,4800,0.1]
[null,"Elizabeth","2021-05-01",36,5000,5.5E-2]

{"sheet":"Dataset (2)","index":8,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Region","Quantity","Cost","Revenue","Profit"]
[null,"Asia",35,27475,29000,{"$f":"E5-D5","v":1525}]
[null,"Europe",54,355428,356890,{"$f":"E6-D6","v":1462}]
[null,"Africa",45,7020,7500,480]
[null,"North America",73,9500,10000,500]
[null,"Africa",85,3825,4825,1000]
[null,"Asia",15,4265,5500,1235]
[null,"Africa",95,24130,32520,8390]
[null,"Europe",82,21730,23000,1270]
[null,"Asia",25,625,725,100]