{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["ISBLANK","COUNTA","OR","AND","COUNTBLANK","IF"],"read":"whole","date_system":"1900"}

{"sheet":"ISBLANK","index":0,"n_rows":11,"n_cols":4,"rows_kept":11}
["Item","Old Stock","New Stock","Calculation"]
["Laptop",15,10,{"$f":"IF(OR(ISBLANK(B2),ISBLANK(C2)),\"\",SUM(B2:C2))","v":25}]
["Smartphone",null,25,{"$f":"IF(OR(ISBLANK(B3),ISBLANK(C3)),\"\",SUM(B3:C3))","v":""}]
["Tablet",12,null,""]
["Headphones",20,18,38]
["Smartwatch",null,null,""]
["Monitor",8,14,22]
["Keyboard",30,null,""]
["Mouse",22,19,41]
["Hard Drive",null,12,""]
["Printer",10,null,""]

{"sheet":"COUNTA","index":1,"n_rows":11,"n_cols":4,"rows_kept":11}
["Item","Old Stock","New Stock","Calculation"]
["Laptop",15,10,{"$f":"IF(COUNTA(B2:C2)=2,SUM(B2:C2),\"\")","v":25}]
["Smartphone",null,25,{"$f":"IF(COUNTA(B3:C3)=2,SUM(B3:C3),\"\")","v":""}]
["Tablet",12,null,""]
["Headphones",20,18,38]
["Smartwatch",null,null,""]
["Monitor",8,14,22]
["Keyboard",30,null,""]
["Mouse",22,19,41]
["Hard Drive",null,12,""]
["Printer",10,null,""]

{"sheet":"OR","index":2,"n_rows":11,"n_cols":4,"rows_kept":11}
["Item","Old Stock","New Stock","Calculation"]
["Laptop",15,10,{"$f":"IF(OR(B2=\"\",C2=\"\"),\"\",SUM(B2:C2))","v":25}]
["Smartphone",null,25,{"$f":"IF(OR(B3=\"\",C3=\"\"),\"\",SUM(B3:C3))","v":""}]
["Tablet",12,null,""]
["Headphones",20,18,38]
["Smartwatch",null,null,""]
["Monitor",8,14,22]
["Keyboard",30,null,""]
["Mouse",22,19,41]
["Hard Drive",null,12,""]
["Printer",10,null,""]

{"sheet":"AND","index":3,"n_rows":11,"n_cols":4,"rows_kept":11}
["Item","Old Stock","New Stock","Calculation"]
["Laptop",15,10,{"$f":"IF(AND(B2<>\"\",C2<>\"\"),SUM(B2:C2),\"\")","v":25}]
["Smartphone",null,25,{"$f":"IF(AND(B3<>\"\",C3<>\"\"),SUM(B3:C3),\"\")","v":""}]
["Tablet",12,null,""]
["Headphones",20,18,38]
["Smartwatch",null,null,""]
["Monitor",8,14,22]
["Keyboard",30,null,""]
["Mouse",22,19,41]
["Hard Drive",null,12,""]
["Printer",10,null,""]

{"sheet":"COUNTBLANK","index":4,"n_rows":11,"n_cols":4,"rows_kept":11}
["Item","Old Stock","New Stock","Calculation"]
["Laptop",15,10,{"$f":"IF(COUNTBLANK(B2:C2)=0,SUM(B2:C2),\"\")","v":25}]
["Smartphone",null,25,{"$f":"IF(COUNTBLANK(B3:C3)=0,SUM(B3:C3),\"\")","v":""}]
["Tablet",12,null,""]
["Headphones",20,18,38]
["Smartwatch",null,null,""]
["Monitor",8,14,22]
["Keyboard",30,null,""]
["Mouse",22,19,41]
["Hard Drive",null,12,""]
["Printer",10,null,""]

{"sheet":"IF","index":5,"n_rows":11,"n_cols":4,"rows_kept":11}
["Item","Old Stock","New Stock","Calculation"]
["Laptop",15,10,{"$f":"IF(B2<>\"\",B2*2,\"\")","v":30}]
["Smartphone",null,25,{"$f":"IF(B3<>\"\",B3*2,\"\")","v":""}]
["Tablet",12,null,24]
["Headphones",20,18,40]
["Smartwatch",null,null,""]
["Monitor",8,14,16]
["Keyboard",30,null,60]
["Mouse",22,19,44]
["Hard Drive",null,12,""]
["Printer",10,null,20]