{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Contents","Introduction ISREF","ISREF","ISREF-DeleteA","ISREF-Sheet2","ISREF-Sheet2-Delete","ISREF-Indirect","Sheet1","ISREF-OFFSET","ISREF-OFFSET-Invalid"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":2,"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":[]}
["ISREF Function"]
[null,"automateexcel.com/functions/isref-formula-excel"]
[]
[null,"Table of Contents",null,null,null,"Other Resources"]
[null,"Introduction ISREF",null,null,null,"Excel Formulas w/Examples"]
[null,"ISREF",null,null,null,"Excel Boot Camp - Learn Excel inside Excel"]
[null,"ISREF-DeleteA",null,null,null,"Excel Functions & Formulas Tutorial"]
[null,"ISREF-Sheet2"]
[null,"ISREF-Sheet2-Delete"]
[null,"ISREF-Indirect"]
[null,"Sheet1"]
[null,"ISREF-OFFSET"]
[null,"ISREF-OFFSET-Invalid"]
[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 ISREF","index":1,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ISREF",null,"=ISREF(value)"]
[null,"The Excel ISREF returns TRUE when a cell contains a reference and FALSE if not."]
[]
[null,"Result","Formula"]
[null,{"$f":"ISREF(A1)","v":true},{"$f":"IF(_xlfn.ISFORMULA(B6),_xlfn.FORMULATEXT(B6),B6)","v":"=ISREF(A1)"}]
[null,{"$f":"ISREF(A1:A10)","v":true},{"$f":"IF(_xlfn.ISFORMULA(B7),_xlfn.FORMULATEXT(B7),B7)","v":"=ISREF(A1:A10)"}]
[null,{"$f":"ISREF(A1+A2)","v":false},"=ISREF(A1+A2)"]
[null,{"$f":"ISREF(3+5)","v":false},"=ISREF(3+5)"]
[null,{"$f":"ISREF([1]Sheet1!A1)","v":true},{"$f":"IF(_xlfn.ISFORMULA(B10),_xlfn.FORMULATEXT(B10),B10)","v":"=ISREF(Sheet1!A1)"}]
[null,{"$f":"ISREF(INDIRECT(\"A1\"))","v":true},"=ISREF(INDIRECT(\"A1\"))"]
[null,{"$f":"ISREF(INDEX(A:E,10,5))","v":true},"=ISREF(INDEX(A:E,10,5))"]
[]
[null,"automateexcel.com/functions/isref-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"ISREF","index":2,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Result","Formula"]
[null,{"$f":"ISREF(A1)","v":true},{"$f":"IF(_xlfn.ISFORMULA(B3),_xlfn.FORMULATEXT(B3),B3)","v":"=ISREF(A1)"}]
[null,{"$f":"ISREF(A1:A7)","v":true},{"$f":"IF(_xlfn.ISFORMULA(B4),_xlfn.FORMULATEXT(B4),B4)","v":"=ISREF(A1:A7)"}]
[null,{"$f":"ISREF(A1+A3)","v":false},{"$f":"IF(_xlfn.ISFORMULA(B5),_xlfn.FORMULATEXT(B5),B5)","v":"=ISREF(A1+A3)"}]
[null,{"$f":"ISREF(3+5)","v":false},"=ISREF(3+5)"]
[null,{"$f":"ISREF([1]Sheet1!A1)","v":true},{"$f":"IF(_xlfn.ISFORMULA(B7),_xlfn.FORMULATEXT(B7),B7)","v":"=ISREF(Sheet1!A1)"}]
[]
[null,"automateexcel.com/functions/isref-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"ISREF-DeleteA","index":3,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
["Result","Formula"]
[{"$f":"ISREF(#REF!)","v":false},{"$f":"IF(_xlfn.ISFORMULA(A3),_xlfn.FORMULATEXT(A3),A3)","v":"=ISREF(#REF!)"}]
[{"$f":"ISREF(#REF!)","v":false},{"$f":"IF(_xlfn.ISFORMULA(A4),_xlfn.FORMULATEXT(A4),A4)","v":"=ISREF(#REF!)"}]
[{"$f":"ISREF(#REF!+#REF!)","v":false},{"$f":"IF(_xlfn.ISFORMULA(A5),_xlfn.FORMULATEXT(A5),A5)","v":"=ISREF(#REF!+#REF!)"}]
[{"$f":"ISREF(3+5)","v":false},"=ISREF(3+5)"]
[{"$f":"ISREF([1]Sheet1!A1)","v":true},{"$f":"IF(_xlfn.ISFORMULA(A7),_xlfn.FORMULATEXT(A7),A7)","v":"=ISREF(Sheet1!A1)"}]
[]
[null,"automateexcel.com/functions/isref-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"ISREF-Sheet2","index":4,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Result","Formula"]
[{"$f":"ISREF([2]Sheet2!A1)","v":true},{"$f":"IF(_xlfn.ISFORMULA(A2),_xlfn.FORMULATEXT(A2),A2)","v":"=ISREF(Sheet2!A1)"}]
[]
[null,"automateexcel.com/functions/isref-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"ISREF-Sheet2-Delete","index":5,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Result","Formula"]
[{"$f":"ISREF(#REF!)","v":false},{"$f":"IF(_xlfn.ISFORMULA(A2),_xlfn.FORMULATEXT(A2),A2)","v":"=ISREF(#REF!)"}]
[]
[null,"automateexcel.com/functions/isref-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"ISREF-Indirect","index":6,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Result","Formula"]
[{"$f":"ISREF(INDIRECT(\"A1\"))","v":true},{"$f":"IF(_xlfn.ISFORMULA(A2),_xlfn.FORMULATEXT(A2),A2)","v":"=ISREF(INDIRECT(\"A1\"))"}]
[{"$f":"ISREF(INDIRECT(\"Sheet1!\"&\"A1\"))","v":true},{"$f":"IF(_xlfn.ISFORMULA(A3),_xlfn.FORMULATEXT(A3),A3)","v":"=ISREF(INDIRECT(\"Sheet1!\"&\"A1\"))"}]
[{"$f":"ISREF(INDIRECT(\"[Book1.xlsx]\"&\"Sheet1!\"&\"A1\"))","v":false},"=ISREF(INDIRECT(\"[Book1.xlsx]\"&\"Sheet1!\"&\"A1\"))"]
[]
[null,"automateexcel.com/functions/isref-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Sheet1","index":7,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"automateexcel.com/functions/isref-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"ISREF-OFFSET","index":8,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Result","Formula"]
[{"$f":"ISREF(OFFSET(D3,3,3))","v":true},{"$f":"IF(_xlfn.ISFORMULA(A2),_xlfn.FORMULATEXT(A2),A2)","v":"=ISREF(OFFSET(D3,3,3))"}]
[{"$f":"ISREF(OFFSET(D3,-3,-3))","v":false},{"$f":"IF(_xlfn.ISFORMULA(A3),_xlfn.FORMULATEXT(A3),A3)","v":"=ISREF(OFFSET(D3,-3,-3))"}]
[]
[null,"automateexcel.com/functions/isref-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"ISREF-OFFSET-Invalid","index":9,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Result","Formula"]
[{"$f":"IF(ISREF(OFFSET(D3,3,3)),OFFSET(D3,3,3),\"invalid range\"\"\")","v":"G6"},{"$f":"IF(_xlfn.ISFORMULA(A2),_xlfn.FORMULATEXT(A2),A2)","v":"=IF(ISREF(OFFSET(D3,3,3)),OFFSET(D3,3,3),\"invalid range\"\"\")"}]
[{"$f":"IF(ISREF(OFFSET(D3,-3,-3)),OFFSET(D3,-3,-3),\"invalid range\")","v":"invalid range"},{"$f":"IF(_xlfn.ISFORMULA(A3),_xlfn.FORMULATEXT(A3),A3)","v":"=IF(ISREF(OFFSET(D3,-3,-3)),OFFSET(D3,-3,-3),\"invalid range\")"},null,"D3","E3","F3","G3"]
[null,null,null,"D4","E4","F4","G4"]
[null,null,null,"D5","E5","F5","G5"]
[null,null,null,"D6","E6","F6","G6"]
[]
[null,"automateexcel.com/functions/isref-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]