{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Contents","Introduction Round","ISFORMULA","IF-ISFORMULA","FORMULATEXT","IF-NOT"],"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":[]}
["ISFORMULA Function"]
[null,"automateexcel.com/functions/isformula-formula-excel"]
[]
[null,"Table of Contents",null,null,null,"Other Resources"]
[null,"Introduction Round",null,null,null,"Excel Formulas w/Examples"]
[null,"ISFORMULA",null,null,null,"Excel Boot Camp - Learn Excel inside Excel"]
[null,"IF-ISFORMULA",null,null,null,"Excel Functions & Formulas Tutorial"]
[null,"FORMULATEXT"]
[null,"IF-NOT"]
[]
[]
[]
[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 Round","index":1,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ISFORMULA",null,"=ISFORMULA (reference)"]
[null,"You can use the ISFORMULA function to test a cell to see if it contains a formula."]
[]
[null,"DATA","Result","Content _Column B"]
[null,"2020-01-01",{"$f":"_xlfn.ISFORMULA(B6)","v":false},{"$f":"IF(_xlfn.ISFORMULA(B6),_xlfn.FORMULATEXT(B6),B6)","v":"2020-01-01"}]
[null,{"$f":"B6+30","v":"2020-01-31"},{"$f":"_xlfn.ISFORMULA(B7)","v":true},{"$f":"IF(_xlfn.ISFORMULA(B7),_xlfn.FORMULATEXT(B7),B7)","v":"=B6+30"}]
[null,{"$f":"B7+30","v":"2020-03-01"},true,"=B7+30"]
[null,"2020-03-31",true,"=B8+30"]
[null,"2020-04-30",true,"=B9+30"]
[null,"2020-05-30",true,"=B10+30"]
[null,"2020-06-29",true,"=B11+30"]
[]
[null,"automateexcel.com/functions/isformula-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"ISFORMULA","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":"_xlfn.ISFORMULA(A2)","v":true},"=TODAY()"]
[{"$f":"10*15","v":150},{"$f":"_xlfn.ISFORMULA(A3)","v":true},"=10*15"]
[150,false,150]
["ABC",{"$f":"_xlfn.ISFORMULA(A5)","v":false},"ABC"]
[]
[null,"automateexcel.com/functions/isformula-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"IF-ISFORMULA","index":3,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["DATA","Result"]
[{"$f":"TODAY()","v":"2021-08-31"},{"$f":"IF(_xlfn.ISFORMULA(A2),\"formula\", \"not formula\")","v":"formula"}]
[{"$f":"10*15","v":150},{"$f":"IF(_xlfn.ISFORMULA(A3),\"formula\", \"not formula\")","v":"formula"}]
[150,"not formula"]
["ABC","not formula"]
[]
[null,"automateexcel.com/functions/isformula-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"FORMULATEXT","index":4,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["DATA","Result"]
[{"$f":"TODAY()","v":"2021-08-31"},{"$f":"IF(_xlfn.ISFORMULA(A2),_xlfn.FORMULATEXT(A2),A2)","v":"=TODAY()"}]
[{"$f":"10*15","v":150},{"$f":"IF(_xlfn.ISFORMULA(A3),_xlfn.FORMULATEXT(A3),A3)","v":"=10*15"}]
[150,150]
["ABC","ABC"]
[]
[null,"automateexcel.com/functions/isformula-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"IF-NOT","index":5,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["DATA","Result"]
[{"$f":"TODAY()","v":"2021-08-31"},{"$f":"IF(NOT(_xlfn.ISFORMULA(A2)),\"not formula\", \"formula\")","v":"formula"}]
[{"$f":"10*15","v":150},{"$f":"IF(NOT(_xlfn.ISFORMULA(A3)),\"not formula\", \"formula\")","v":"formula"}]
[150,{"$f":"IF(NOT(_xlfn.ISFORMULA(A4)),\"not formula\", \"formula\")","v":"not formula"}]
["ABC","not formula"]
[]
[null,"automateexcel.com/functions/isformula-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]