{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Contents","Introduction ISBLANK ","ISNUMBER","Presentage-Number","Number-Or-Not","IF-NOT-Number","Search-ISNumber","Search-ISNumber-Case-Sensitive","Match-ISNumber","ISNUMBER-Validity","Test-IsNumber","Data Validation"],"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":[]}
["ISNUMBER Function"]
[null,"automateexcel.com/functions/isnumber-formula-excel"]
[]
[null,"Table of Contents",null,null,null,"Other Resources"]
[null,"Introduction ISBLANK ",null,null,null,"Excel Formulas w/Examples"]
[null,"ISNUMBER",null,null,null,"Excel Boot Camp - Learn Excel inside Excel"]
[null,"Presentage-Number",null,null,null,"Excel Functions & Formulas Tutorial"]
[null,"Number-Or-Not"]
[null,"IF-NOT-Number"]
[null,"Search-ISNumber"]
[null,"Search-ISNumber-Case-Sensitive"]
[null,"Match-ISNumber"]
[null,"ISNUMBER-Validity"]
[null,"Test-IsNumber"]
[null,"Data Validation"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ISNUMBER ",null,"=ISNUMBER (value)"]
[null,"Use the ISNUMBER function to check if a value is a number. "]
[]
[null,"DATA","Result","Content _Column B"]
[null,12345,{"$f":"ISNUMBER(B6)","v":true},12345]
[null,"12345",false,"12345 (Text Format)"]
[null,"A12345",false,"A12345"]
[null,{"$f":"TODAY()","v":"2021-08-31"},true,"=TODAY()"]
[null,{"$f":"NOW()","v":44439.893762384258},true,"=NOW()"]
[null,"ABCD",false,"ABCD"]
[null,{"$f":"150-25","v":125},true,"=150-25"]
[]
[null,"automateexcel.com/functions/isnumber-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"ISNUMBER","index":2,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["DATA","Result","Content _Column B"]
[12345,{"$f":"ISNUMBER(A2)","v":true},12345]
["12345",{"$f":"ISNUMBER(A3)","v":false},"12345 (Text Format)"]
["A12345",false,"A12345"]
["ABCD",false,"ABCD"]
[{"$f":"150-25","v":125},true,"=150-25"]
[]
[null,"automateexcel.com/functions/isnumber-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Presentage-Number","index":3,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["DATA","Result","Content"]
[12345,{"$f":"ISNUMBER(A2)","v":true},"Number"]
["12345",{"$f":"ISNUMBER(A3)","v":false},"Number in Text Format"]
[0.89749999999999996,true,"Percentage"]
["2020-01-01",true,"Date"]
[{"$f":"NOW()","v":44439.893762384258},true,"Time"]
[{"$f":"150-25","v":125},true,"Function (Out put is Number)"]
[676.78,{"$f":"ISNUMBER(A8)","v":true},"Currency"]
[]
[null,"automateexcel.com/functions/isnumber-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Number-Or-Not","index":4,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["DATA","Result","Content"]
[12345,{"$f":"IF(ISNUMBER(A2),\"number\", \"not a number\")","v":"number"},"Number"]
["12345",{"$f":"IF(ISNUMBER(A3),\"number\", \"not a number\")","v":"not a number"},"Number in Text Format"]
[0.89749999999999996,"number","Percentage"]
["2020-01-01","number","Date"]
[{"$f":"NOW()","v":44439.893762384258},"number","Time"]
[]
[null,"automateexcel.com/functions/isnumber-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"IF-NOT-Number","index":5,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["DATA","Result","Content"]
[12345,{"$f":"IF(NOT(ISNUMBER(A2)), \"not a number\",\"number\")","v":"number"},"Number"]
["12345",{"$f":"IF(NOT(ISNUMBER(A3)), \"not a number\",\"number\")","v":"not a number"},"Number in Text Format"]
[0.89749999999999996,{"$f":"IF(NOT(ISNUMBER(A4)), \"not a number\",\"number\")","v":"number"},"Percentage"]
["2020-01-01","number","Date"]
[{"$f":"NOW()","v":44439.893762384258},"number","Time"]
[]
[null,"automateexcel.com/functions/isnumber-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Search-ISNumber","index":6,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Item","Red","White","Green"]
["Cami-XL-Red-Plane",{"$f":"ISNUMBER(SEARCH(B$1, $A2))","v":true},{"$f":"ISNUMBER(SEARCH(C$1, $A2))","v":false},false]
["Gown-Green-L-Bow",false,false,true]
["TShirt-M-White-Print",false,true,false]
["Geans-Green-XXL",false,false,true]
["Blouse-XL-Green",false,false,true]
[]
[null,"automateexcel.com/functions/isnumber-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Search-ISNumber-Case-Sensitive","index":7,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Item","Result_Search","Result_Find"]
["Cami-XL-Red-Plane",{"$f":"ISNUMBER(SEARCH(\"Red\", $A2))","v":true},{"$f":"ISNUMBER(FIND(\"Red\", $A2))","v":true},null,"=ISNUMBER(FIND(\"Red\", $A2))"]
["Gown-RED-L-Bow",{"$f":"ISNUMBER(SEARCH(\"Red\", $A3))","v":true},false]
["TShirt-M-red-Print",{"$f":"ISNUMBER(SEARCH(\"Red\", $A4))","v":true},false]
["Geans-RED-XXL",true,false]
["Blouse-XL-Red",true,true]
[]
[null,"automateexcel.com/functions/isnumber-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Match-ISNumber","index":8,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Item","Result"]
["Cami-XL-Red-Plane",{"$f":"MATCH(\"Red\", $A2)","v":1}]
["TShirt-M-White-Print",{"$f":"MATCH(\"Red\", $A3)","v":{"$error":"#N/A"}}]
[]
[null,"automateexcel.com/functions/isnumber-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"ISNUMBER-Validity","index":9,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Question","Answer","Validity"]
["1. Date of Birth?","2000-01-01",{"$f":"IF(B2=\"\",\"\",IF(ISNUMBER(B2),\"\",\"Invalid Entry\"))","v":""}]
["2. Age (Years) ?","ABC",{"$f":"IF(B3=\"\",\"\",IF(ISNUMBER(B3),\"\",\"Invalid Entry\"))","v":"Invalid Entry"}]
["3. Expected Salary ?",2000,""]
[]
[null,"automateexcel.com/functions/isnumber-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Test-IsNumber","index":10,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Range 01","Range 02","Range 03",null,"Range","Result"]
[100,"Orange","Alex",null,{"$f":"Table11517101198102347[[#Headers],[Range 01]]","v":"Range 01"},{"$f":"SUMPRODUCT(--ISNUMBER(A2:A6))>0","v":true}]
[200,"Grapes","Smith",null,{"$f":"Table11517101198102347[[#Headers],[Range 02]]","v":"Range 02"},{"$f":"SUMPRODUCT(--ISNUMBER(B2:B6))>0","v":true}]
[300,"Apple","John",null,{"$f":"Table11517101198102347[[#Headers],[Range 03]]","v":"Range 03"},{"$f":"SUMPRODUCT(--ISNUMBER(C2:C6))>0","v":false}]
[400,100,"Jeremy"]
[500,"Banana","Michel"]
[]
[null,"automateexcel.com/functions/isnumber-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Data Validation","index":11,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Value 01","Value 02","Value 03"]
["ABCD",7679,"X8790"]
[5678,"6729V",8908]
["X5627",1899,"C6877"]
["C7289",6767,"C6527"]
[]
[null,"automateexcel.com/functions/isnumber-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]