{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Contents","Introduction ISBLANK ","ISBLANK ","IF-ISBLANK","IF-NOT-ISBLANK","COUNTBLANK","IF-COUNTBLANK","Not-Working-ISBLANK","LEN-ISBLANK"],"not_rendered":{"charts":0,"images":2,"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":"Contents","index":0,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["ISBLANK Function"]
[null,"automateexcel.com/functions/isblank-formula-excel"]
[]
[null,"Table of Contents",null,null,null,"Other Resources"]
[null,"Introduction ISBLANK ",null,null,null,"Excel Formulas w/Examples"]
[null,"ISBLANK ",null,null,null,"Excel Boot Camp - Learn Excel inside Excel"]
[null,"IF-ISBLANK",null,null,null,"Excel Functions & Formulas Tutorial"]
[null,"IF-NOT-ISBLANK"]
[null,"COUNTBLANK"]
[null,"IF-COUNTBLANK"]
[null,"Not-Working-ISBLANK"]
[null,"LEN-ISBLANK"]
[null,"Excel Boot Camp"]
[null,"  Learn Excel Inside Excel"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"           Learn Excel inside Excel with our Interactive Tutorial"]
[null,"           Automatically Graded Exercises"]
[null,"           Shortcuts & Best Practices \"Work Smarter, not Harder\""]
[]
[]
[]
[]
[]
[]
[]
[null,"Course Contents"]

{"sheet":"Introduction ISBLANK ","index":1,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ISBLANK ",null,"=ISBLANK (value)"]
[null,"The Excel ISBLANK function returns TRUE when a cell contains is empty, and FALSE when a cell is not empty."]
[]
[null,"DATA","Result","Content _Column B"]
[null,{"$f":"TODAY()","v":"2021-08-31"},{"$f":"ISBLANK(B6)","v":false},"=TODAY()"]
[null,null,{"$f":"ISBLANK(B7)","v":true}]
[null,"ABCD",{"$f":"ISBLANK(B8)","v":false},"ABCD"]
[null,{"$f":"IF(B6>0,\"\",B8)","v":""},{"$f":"ISBLANK(B9)","v":false},"=IF(B6>0,\"\",B8)"]
[]
[null,"automateexcel.com/functions/isblank-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"ISBLANK ","index":2,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["DATA","Result","Content _Column A"]
[{"$f":"TODAY()","v":"2021-08-31"},{"$f":"ISBLANK(A2)","v":false},"=TODAY()"]
[null,{"$f":"ISBLANK(A3)","v":true}]
["ABCD",{"$f":"ISBLANK(A4)","v":false},"ABCD"]
[{"$f":"IF(A2>0,\"\",A4)","v":""},{"$f":"ISBLANK(A5)","v":false},"=IF(B6>0,\"\",B8)"]
[]
[null,"automateexcel.com/functions/isblank-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"IF-ISBLANK","index":3,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Item","Stock","Sold","Unit Price ($)","Sales"]
["Apples",52,25,5,{"$f":"IF(ISBLANK(C2),\"\",C2*D2)","v":125}]
["Bananas",69,5,7,{"$f":"IF(ISBLANK(C3),\"\",C3*D3)","v":35}]
["Oranges",87,null,9,""]
["Pineapple",56,2,10,20]
["Grapes",67,null,6,""]
[]
[null,"automateexcel.com/functions/isblank-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"IF-NOT-ISBLANK","index":4,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Item","Stock","Sold","Unit Price ($)","Sales"]
["Apples",52,25,5,{"$f":"IF(NOT(ISBLANK(C2)),C2*D2,\"\")","v":125}]
["Bananas",69,5,7,{"$f":"IF(NOT(ISBLANK(C3)),C3*D3,\"\")","v":35}]
["Oranges",87,null,9,""]
["Pineapple",56,2,10,20]
["Grapes",67,null,6,""]
[]
[null,"automateexcel.com/functions/isblank-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"COUNTBLANK","index":5,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["1-Jan","2-Jan","3-Jan",null,"Result"]
[0.10158976340847092,3.6091369052667854E-2,0.59333655978166666,null,{"$f":"COUNTBLANK(A2:C7)","v":5}]
[null,0.46430186828304809]
[0.11508364123999881,0.90711100996385308,0.65498029904393851]
[0.13919197010719708,null,0.84621282508499218]
[null,0.46359840520421713,0.86381277869839102]
[0.77039049919665159,0.10482956214342831]
[]
[null,"automateexcel.com/functions/isblank-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"IF-COUNTBLANK","index":6,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["1-Jan","2-Jan","3-Jan",null,"Pay_amount"]
[0.10158976340847092,3.6091369052667854E-2,0.59333655978166666,null,{"$f":"IF(COUNTBLANK(A2:C2)>0,100*SUM(A2:C2),200*SUM(A2:C2))","v":146.20353844856109}]
[null,0.46430186828304809,null,null,{"$f":"IF(COUNTBLANK(A3:C3)>0,100*SUM(A3:C3),200*SUM(A3:C3))","v":46.430186828304812}]
[0.11508364123999881,0.90711100996385308,0.65498029904393851,null,{"$f":"IF(COUNTBLANK(A4:C4)>0,100*SUM(A4:C4),200*SUM(A4:C4))","v":335.43499004955811}]
[0.13919197010719708,null,0.84621282508499218,null,98.54047951921892]
[0.13919197010719708,0.46359840520421713,0.86381277869839102,null,293.32063080196104]
[0.77039049919665159,0.10482956214342831,null,null,87.522006134007995]
[]
[null,"automateexcel.com/functions/isblank-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Not-Working-ISBLANK","index":7,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["DATA","Result_ISBLANK","Result","Content _Column A"]
[{"$f":"TODAY()","v":"2021-08-31"},{"$f":"IF(ISBLANK(A2),\"blank\",\"not blank\")","v":"not blank"},{"$f":"IF(OR(ISBLANK(A2),A2=\"\"),\"blank\",\"not blank\")","v":"not blank"},"=TODAY()"]
[null,"blank","blank"]
["ABCD","not blank","not blank","ABCD"]
[{"$f":"IF(A2>0,\"\",A4)","v":""},"not blank","blank","=IF(B6>0,\"\",B8)"]
[{"$f":"\"\"","v":""},"not blank","blank","=\"\""]
[{"$f":"CHAR(160)","v":" "},"not blank","not blank","=CHAR(160)"]
[]
[null,"automateexcel.com/functions/isblank-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"LEN-ISBLANK","index":8,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Data","Len()","ISBLANK","With_Trim","Content _Column A"]
["ABCD",{"$f":"LEN(A2)","v":4},{"$f":"IF(ISBLANK(A2),\"blank\",\"nonblank\")","v":"nonblank"},{"$f":"IF(OR(A2=\" \", LEN(TRIM(A2))=0), \"blank\", \"not blank\")","v":"not blank"},"ABCD",null,"=IF(OR(A2=\" \", LEN(TRIM(A2))=0), \"blank\", \"not blank\")"]
[100,3,"nonblank",{"$f":"IF(OR(A3=\" \", LEN(TRIM(A3))=0), \"blank\", \"not blank\")","v":"not blank"},100]
[" ",{"$f":"LEN(A4)","v":1},"nonblank","blank","SPACE(\" \")"]
[null,0,"blank","blank","Blank"]
[]
[null,"automateexcel.com/functions/isblank-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]