{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","Manually","Replace option","Go to Special","shortcut key","VBA","SUBSTITUTE","REPLACE","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":"Dataset","index":0,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"\"ABC\" Company"]
[]
[null,"Product","Price","Discounted Price",">2000 or not"]
[null,"Orange",1477,{"$f":"C5-C5*0.06","v":1388.38},{"$f":"IF(C5>2000,\"Yes\",\"Small Value\")","v":"Small Value"}]
[null,"Apple",1574,{"$f":"C6-C6*0.06","v":1479.56},{"$f":"IF(C6>2000,\"Yes\",\"Small Value\")","v":"Small Value"}]
[null,"Kiwi",3458,{"$f":"C7-C7*0.06","v":3250.52},{"$f":"IF(C7>2000,\"Yes\",\"Small Value\")","v":"Yes"}]
[null,"Watermelon",2507,{"$f":"C8-C8*0.06","v":2356.58},{"$f":"IF(C8>2000,\"Yes\",\"Small Value\")","v":"Yes"}]
[null,"Banana",3101,{"$f":"C9-C9*0.06","v":2914.94},{"$f":"IF(C9>2000,\"Yes\",\"Small Value\")","v":"Yes"}]
[null,"Avocado",2672,{"$f":"C10-C10*0.06","v":2511.6799999999998},{"$f":"IF(C10>2000,\"Yes\",\"Small Value\")","v":"Yes"}]
[null,"Lemon",1695,{"$f":"C11-C11*0.06","v":1593.3},{"$f":"IF(C11>2000,\"Yes\",\"Small Value\")","v":"Small Value"}]
[null,"Tomato",3511,{"$f":"C12-C12*0.06","v":3300.34},{"$f":"IF(C12>2000,\"Yes\",\"Small Value\")","v":"Yes"}]
[null,"Blackberry",3596,{"$f":"C13-C13*0.06","v":3380.24},{"$f":"IF(C13>2000,\"Yes\",\"Small Value\")","v":"Yes"}]

{"sheet":"Manually","index":1,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Replacing Manually"]
[]
[null,"Product","Price",">2000 or not"]
[null,"Orange",1477,{"$f":"IF(C5>2000,\"Greater than 2000\",\"Small Value\")","v":"Small Value"}]
[null,"Apple",1574,{"$f":"IF(C6>2000,\"Greater than 2000\",\"Small Value\")","v":"Small Value"}]
[null,"Kiwi",3458,"Greater than 2000"]
[null,"Watermelon",2507,"Greater than 2000"]
[null,"Banana",3101,"Greater than 2000"]
[null,"Avocado",2672,"Greater than 2000"]
[null,"Lemon",1695,"Small Value"]
[null,"Tomato",3511,"Greater than 2000"]
[null,"Blackberry",3596,"Greater than 2000"]

{"sheet":"Replace option","index":2,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Replace Option"]
[]
[null,"Product","Price",">2000 or not"]
[null,"Orange",1477,{"$f":"IF(C5>2000,\"Yes\",\"Small Value\")","v":"Small Value"}]
[null,"Apple",1574,{"$f":"IF(C6>2000,\"Greater than 2000\",\"Small Value\")","v":"Small Value"}]
[null,"Kiwi",3458,{"$f":"IF(C7>2000,\"Greater than 2000\",\"Small Value\")","v":"Greater than 2000"}]
[null,"Watermelon",2507,{"$f":"IF(C8>2000,\"Greater than 2000\",\"Small Value\")","v":"Greater than 2000"}]
[null,"Banana",3101,{"$f":"IF(C9>2000,\"Greater than 2000\",\"Small Value\")","v":"Greater than 2000"}]
[null,"Avocado",2672,{"$f":"IF(C10>2000,\"Greater than 2000\",\"Small Value\")","v":"Greater than 2000"}]
[null,"Lemon",1695,{"$f":"IF(C11>2000,\"Greater than 2000\",\"Small Value\")","v":"Small Value"}]
[null,"Tomato",3511,{"$f":"IF(C12>2000,\"Greater than 2000\",\"Small Value\")","v":"Greater than 2000"}]
[null,"Blackberry",3596,{"$f":"IF(C13>2000,\"Greater than 2000\",\"Small Value\")","v":"Greater than 2000"}]

{"sheet":"Go to Special","index":3,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Go to Special Option"]
[]
[null,"Product","Price",">2000 or not"]
[null,"Orange",1477,{"$f":"IF(C5>2000,\"Greater than 2000\",\"Small Value\")","v":"Small Value"}]
[null,"Apple",1574,{"$f":"IF(C6>2000,\"Greater than 2000\",\"Small Value\")","v":"Small Value"}]
[null,"Kiwi",3458,{"$f":"IF(C7>2000,\"Greater than 2000\",\"Small Value\")","v":"Greater than 2000"}]
[null,"Watermelon",2507,{"$f":"IF(C8>2000,\"Greater than 2000\",\"Small Value\")","v":"Greater than 2000"}]
[null,"Banana",3101,{"$f":"IF(C9>2000,\"Greater than 2000\",\"Small Value\")","v":"Greater than 2000"}]
[null,"Avocado",2672,{"$f":"IF(C10>2000,\"Greater than 2000\",\"Small Value\")","v":"Greater than 2000"}]
[null,"Lemon",1695,{"$f":"IF(C11>2000,\"Greater than 2000\",\"Small Value\")","v":"Small Value"}]
[null,"Tomato",3511,{"$f":"IF(C12>2000,\"Greater than 2000\",\"Small Value\")","v":"Greater than 2000"}]
[null,"Blackberry",3596,{"$f":"IF(C13>2000,\"Greater than 2000\",\"Small Value\")","v":"Greater than 2000"}]

{"sheet":"shortcut key","index":4,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Shortcut Key"]
[]
[null,"Product","Price",">2000 or not"]
[null,"Orange",1477,{"$f":"IF(C5>2000,\"Greater than 2000\",\"Small Value\")","v":"Small Value"}]
[null,"Apple",1574,{"$f":"IF(C6>2000,\"Greater than 2000\",\"Small Value\")","v":"Small Value"}]
[null,"Kiwi",3458,{"$f":"IF(C7>2000,\"Greater than 2000\",\"Small Value\")","v":"Greater than 2000"}]
[null,"Watermelon",2507,{"$f":"IF(C8>2000,\"Greater than 2000\",\"Small Value\")","v":"Greater than 2000"}]
[null,"Banana",3101,{"$f":"IF(C9>2000,\"Greater than 2000\",\"Small Value\")","v":"Greater than 2000"}]
[null,"Avocado",2672,{"$f":"IF(C10>2000,\"Greater than 2000\",\"Small Value\")","v":"Greater than 2000"}]
[null,"Lemon",1695,{"$f":"IF(C11>2000,\"Greater than 2000\",\"Small Value\")","v":"Small Value"}]
[null,"Tomato",3511,{"$f":"IF(C12>2000,\"Greater than 2000\",\"Small Value\")","v":"Greater than 2000"}]
[null,"Blackberry",3596,{"$f":"IF(C13>2000,\"Greater than 2000\",\"Small Value\")","v":"Greater than 2000"}]

{"sheet":"VBA","index":5,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using VBA Code"]
[]
[null,"Product","Price","Discounted Price"]
[null,"Orange",1477,{"$f":"C5-C5*0.04","v":1417.92}]
[null,"Apple",1574,{"$f":"C6-C6*0.04","v":1511.04}]
[null,"Kiwi",3458,{"$f":"C7-C7*0.04","v":3319.68}]
[null,"Watermelon",2507,{"$f":"C8-C8*0.04","v":2406.7199999999998}]
[null,"Banana",3101,{"$f":"C9-C9*0.04","v":2976.96}]
[null,"Avocado",2672,{"$f":"C10-C10*0.04","v":2565.12}]
[null,"Lemon",1695,{"$f":"C11-C11*0.04","v":1627.2}]
[null,"Tomato",3511,{"$f":"C12-C12*0.04","v":3370.56}]
[null,"Blackberry",3596,{"$f":"C13-C13*0.04","v":3452.16}]

{"sheet":"SUBSTITUTE","index":6,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"SUBSTITUTE and FORMULATEXT Function"]
[]
[null,"Product","Price","Discounted Price","Formula","New Price"]
[null,"Orange",1477,{"$f":"C5-C5*0.06","v":1388.38},{"$f":"SUBSTITUTE(_xlfn.FORMULATEXT(D5),0.06,0.04)","v":"=C5-C5*0.04"},{"$f":"EVAL(E5)","v":1417.92}]
[null,"Apple",1574,{"$f":"C6-C6*0.06","v":1479.56},{"$f":"SUBSTITUTE(_xlfn.FORMULATEXT(D6),0.06,0.04)","v":"=C6-C6*0.04"},{"$f":"EVAL(E6)","v":1511.04}]
[null,"Kiwi",3458,{"$f":"C7-C7*0.06","v":3250.52},"=C7-C7*0.04",{"$f":"EVAL(E7)","v":3319.68}]
[null,"Watermelon",2507,{"$f":"C8-C8*0.06","v":2356.58},"=C8-C8*0.04",{"$f":"EVAL(E8)","v":2406.7199999999998}]
[null,"Banana",3101,{"$f":"C9-C9*0.06","v":2914.94},"=C9-C9*0.04",{"$f":"EVAL(E9)","v":2976.96}]
[null,"Avocado",2672,{"$f":"C10-C10*0.06","v":2511.6799999999998},"=C10-C10*0.04",{"$f":"EVAL(E10)","v":2565.12}]
[null,"Lemon",1695,{"$f":"C11-C11*0.06","v":1593.3},"=C11-C11*0.04",{"$f":"EVAL(E11)","v":1627.2}]
[null,"Tomato",3511,{"$f":"C12-C12*0.06","v":3300.34},"=C12-C12*0.04",{"$f":"EVAL(E12)","v":3370.56}]
[null,"Blackberry",3596,{"$f":"C13-C13*0.06","v":3380.24},"=C13-C13*0.04",{"$f":"EVAL(E13)","v":3452.16}]

{"sheet":"REPLACE","index":7,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"REPLACE and FORMULATEXT Function"]
[]
[null,"Product","Price","Discounted Price","Formula","New Price"]
[null,"Orange",1477,{"$f":"C5-C5*0.06","v":1388.38},{"$f":"REPLACE(_xlfn.FORMULATEXT(D5),FIND(\"*\",_xlfn.FORMULATEXT(D5),1)+1,4,0.04)","v":"=C5-C5*0.04"},{"$f":"EVAL(E5)","v":1417.92}]
[null,"Apple",1574,{"$f":"C6-C6*0.06","v":1479.56},{"$f":"REPLACE(_xlfn.FORMULATEXT(D6),FIND(\"*\",_xlfn.FORMULATEXT(D6),1)+1,4,0.04)","v":"=C6-C6*0.04"},{"$f":"EVAL(E6)","v":1511.04}]
[null,"Kiwi",3458,{"$f":"C7-C7*0.06","v":3250.52},"=C7-C7*0.04",{"$f":"EVAL(E7)","v":3319.68}]
[null,"Watermelon",2507,{"$f":"C8-C8*0.06","v":2356.58},"=C8-C8*0.04",{"$f":"EVAL(E8)","v":2406.7199999999998}]
[null,"Banana",3101,{"$f":"C9-C9*0.06","v":2914.94},"=C9-C9*0.04",{"$f":"EVAL(E9)","v":2976.96}]
[null,"Avocado",2672,{"$f":"C10-C10*0.06","v":2511.6799999999998},"=C10-C10*0.04",{"$f":"EVAL(E10)","v":2565.12}]
[null,"Lemon",1695,{"$f":"C11-C11*0.06","v":1593.3},"=C11-C11*0.04",{"$f":"EVAL(E11)","v":1627.2}]
[null,"Tomato",3511,{"$f":"C12-C12*0.06","v":3300.34},"=C12-C12*0.04",{"$f":"EVAL(E12)","v":3370.56}]
[null,"Blackberry",3596,{"$f":"C13-C13*0.06","v":3380.24},"=C13-C13*0.04",{"$f":"EVAL(E13)","v":3452.16}]

{"sheet":"Practice","index":8,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Practice"]
[]
[null,"Product","Price","Discounted Price",">2000 or not"]
[null,"Orange",1477,{"$f":"C5-C5*0.06","v":1388.38},{"$f":"IF(C5>2000,\"Yes\",\"Small Value\")","v":"Small Value"}]
[null,"Apple",1574,{"$f":"C6-C6*0.06","v":1479.56},{"$f":"IF(C6>2000,\"Yes\",\"Small Value\")","v":"Small Value"}]
[null,"Kiwi",3458,{"$f":"C7-C7*0.06","v":3250.52},{"$f":"IF(C7>2000,\"Yes\",\"Small Value\")","v":"Yes"}]
[null,"Watermelon",2507,{"$f":"C8-C8*0.06","v":2356.58},{"$f":"IF(C8>2000,\"Yes\",\"Small Value\")","v":"Yes"}]
[null,"Banana",3101,{"$f":"C9-C9*0.06","v":2914.94},{"$f":"IF(C9>2000,\"Yes\",\"Small Value\")","v":"Yes"}]
[null,"Avocado",2672,{"$f":"C10-C10*0.06","v":2511.6799999999998},{"$f":"IF(C10>2000,\"Yes\",\"Small Value\")","v":"Yes"}]
[null,"Lemon",1695,{"$f":"C11-C11*0.06","v":1593.3},{"$f":"IF(C11>2000,\"Yes\",\"Small Value\")","v":"Small Value"}]
[null,"Tomato",3511,{"$f":"C12-C12*0.06","v":3300.34},{"$f":"IF(C12>2000,\"Yes\",\"Small Value\")","v":"Yes"}]
[null,"Blackberry",3596,{"$f":"C13-C13*0.06","v":3380.24},{"$f":"IF(C13>2000,\"Yes\",\"Small Value\")","v":"Yes"}]