{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Quick View","INT_Positive Number","INT Negative Number","INT_Getting Decimal Value","INT_Decimal Serial Number","INT_Splitting Date-Time","INT_Age","INT with IF","INT VBA","INT_RoundUp"],"not_rendered":{"charts":0,"images":0,"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":"Quick View","index":0,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[3,1,3,4],[4,1,4,4],[1,1,1,4]]}
[]
[null,"INT Function Excel"]
[]
[null,"Rounds a number down to the nearest integer"]
[null,"=INT(number)"]
[]
[null,"Input","Nearest Integer","Formula","Explanation"]
[null,50.78,{"$f":"INT(B8)","v":50},{"$f":"_xlfn.FORMULATEXT(C8)","v":"=INT(B8)"},"Rounds down to 50"]
[null,30.91,{"$f":"INT(B9)","v":30},{"$f":"_xlfn.FORMULATEXT(C9)","v":"=INT(B9)"},"Rounds down to 30"]
[null,0.56000000000000005,0,"=INT(B10)","Rounds down to 0"]
[null,-0.78,-1,"=INT(B11)","Rounds down to more negative value (-1)"]
[null,-2.12,-3,"=INT(B12)","Rounds down to more negative value (-3)"]
[null,-10.51,-11,"=INT(B13)","Rounds down to more negative value (-11)"]
[null,"2001-08-12T12:24:00","2001-08-12","=INT(B14)","Splits date from date-time"]
[null,"abc",{"$error":"#VALUE!"},"=INT(B15)","Shows #VALUE! When text value is inserted as input"]

{"sheet":"INT_Positive Number","index":1,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,12]]}
[]
[null,"Use of INT Function with Positive Number",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Name","Actual Weight","Rounded Weight","Formula",null,null,null,null,null,"Name","Actual Weight","Rounded Weight"]
[null,"Bred",50.78,{"$f":"INT(C5)","v":50},{"$f":"_xlfn.FORMULATEXT(D5)","v":"=INT(C5)"},null,null,null,null,null,"Bred",50.78]
[null,"Olivia",30.91,{"$f":"INT(C6)","v":30},{"$f":"_xlfn.FORMULATEXT(D6)","v":"=INT(C6)"},null,null,null,null,null,"Olivia",30.91]
[null,"James",40.51,40,"=INT(C7)",null,null,null,null,null,"James",40.51]
[null,"David",29.2,29,"=INT(C8)",null,null,null,null,null,"David",29.2]
[null,"Leslie",78.41,78,"=INT(C9)",null,null,null,null,null,"Leslie",78.41]
[null,"Hulk",80.52,80,"=INT(C10)",null,null,null,null,null,"Hulk",80.52]
[null,"Michael",62.12,62,"=INT(C11)",null,null,null,null,null,"Michael",62.12]

{"sheet":"INT Negative Number","index":2,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,12]]}
[]
[null,"INT Function when Number is Negative",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Area","Actual Temperature","Rounded Temperature","Formula",null,null,null,null,null,"Area","Actual Temperature","Rounded Temperature"]
[null,"Area 1",-0.52,{"$f":"INT(C5)","v":-1},{"$f":"_xlfn.FORMULATEXT(D5)","v":"=INT(C5)"},null,null,null,null,null,"Area 1",-0.52]
[null,"Area 2",-2.12,{"$f":"INT(C6)","v":-3},{"$f":"_xlfn.FORMULATEXT(D6)","v":"=INT(C6)"},null,null,null,null,null,"Area 2",-2.12]
[null,"Area 3",-10.51,-11,"=INT(C7)",null,null,null,null,null,"Area 3",-10.51]
[null,"Area 4",-29.2,-30,"=INT(C8)",null,null,null,null,null,"Area 4",-29.2]
[null,"Area 5",-18.41,-19,"=INT(C9)",null,null,null,null,null,"Area 5",-18.41]
[null,"Area 6",-20.67,-21,"=INT(C10)",null,null,null,null,null,"Area 6",-20.67]
[null,"Area 7",-30.91,-31,"=INT(C11)",null,null,null,null,null,"Area 7",-30.91]

{"sheet":"INT_Getting Decimal Value","index":3,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,12]]}
[]
[null,"INT Function to Get Decimal Value",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Name","Weight","Decimal Value","Formula",null,null,null,null,null,"Name","Actual Weight","Decimal Value"]
[null,"Bred",50.78,{"$f":"C5-INT(C5)","v":0.78000000000000114},{"$f":"_xlfn.FORMULATEXT(D5)","v":"=C5-INT(C5)"},null,null,null,null,null,"Bred",50.78]
[null,"Olivia",30.91,{"$f":"C6-INT(C6)","v":0.91000000000000014},{"$f":"_xlfn.FORMULATEXT(D6)","v":"=C6-INT(C6)"},null,null,null,null,null,"Olivia",30.91]
[null,"James",40.51,0.50999999999999801,"=C7-INT(C7)",null,null,null,null,null,"James",40.51]
[null,"David",29.2,0.19999999999999929,"=C8-INT(C8)",null,null,null,null,null,"David",29.2]
[null,"Leslie",78.41,0.40999999999999659,"=C9-INT(C9)",null,null,null,null,null,"Leslie",78.41]
[null,"Hulk",80.52,0.51999999999999602,"=C10-INT(C10)",null,null,null,null,null,"Hulk",80.52]
[null,"Michael",62.12,0.11999999999999744,"=C11-INT(C11)",null,null,null,null,null,"Michael",62.12]

{"sheet":"INT_Decimal Serial Number","index":4,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,10,1,13]]}
[]
[null,"INT Function when Serial Number has Decimal Value",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Name","Birth Date-Time","Date to Number","Birth Date","Formula",null,null,null,null,"Name","Birth Date-Time","Date to Number","Birth Date"]
[null,"Bred","2001-08-12T12:24:00",{"$f":"VALUE(C5)","v":37115.51666666667},{"$f":"INT(D5)","v":"2001-08-12"},{"$f":"_xlfn.FORMULATEXT(E5)","v":"=INT(D5)"},null,null,null,null,"Bred","2001-08-12T12:24:00"]
[null,"Olivia","2002-10-13T14:30:00",{"$f":"VALUE(C6)","v":37542.604166666664},{"$f":"INT(D6)","v":"2002-10-13"},{"$f":"_xlfn.FORMULATEXT(E6)","v":"=INT(D6)"},null,null,null,null,"Olivia","2002-10-13T14:30:00"]
[null,"James","2003-12-14T16:35:59.990",37969.691666550927,"2003-12-14","=INT(D7)",null,null,null,null,"James","2003-12-14T16:35:59.990"]
[null,"David","2005-02-13T18:41:59.985",38396.779166493056,"2005-02-13","=INT(D8)",null,null,null,null,"David","2005-02-13T18:41:59.985"]
[null,"Leslie","2006-04-16T20:47:59.980",38823.866666435184,"2006-04-16","=INT(D9)",null,null,null,null,"Leslie","2006-04-16T20:47:59.980"]
[null,"Hulk","2007-06-17T22:53:59.975",39250.954166377313,"2007-06-17","=INT(D10)",null,null,null,null,"Hulk","2007-06-17T22:53:59.975"]
[null,"Michael","2008-08-18T00:59:59.970",39678.041666319441,"2008-08-18","=INT(D11)",null,null,null,null,"Michael","2008-08-18T01:43:00"]

{"sheet":"INT_Splitting Date-Time","index":5,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,10,1,13]]}
[]
[null,"Using INT Function to Split Date-Time",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Name","Birth Date-Time","Birth Date","Birth Time","Formula",null,null,null,null,"Name","Birth Date-Time","Birth Date","Birth Time"]
[null,"Bred","2001-08-12T12:24:00",{"$f":"INT(C5)","v":"2001-08-12"},{"$f":"C5-INT(C5)","v":"12:24:00"},{"$f":"_xlfn.FORMULATEXT(E5)","v":"=C5-INT(C5)"},null,null,null,null,"Bred","2001-08-12T12:24:00"]
[null,"Olivia","2002-10-13T14:30:00",{"$f":"INT(C6)","v":"2002-10-13"},{"$f":"C6-INT(C6)","v":"14:30:00"},{"$f":"_xlfn.FORMULATEXT(E6)","v":"=C6-INT(C6)"},null,null,null,null,"Olivia","2002-10-13T14:30:00"]
[null,"James","2003-12-14T16:35:59.990","2003-12-14","16:35:59.990","=C7-INT(C7)",null,null,null,null,"James","2003-12-14T16:35:59.990"]
[null,"David","2005-02-13T18:41:59.985","2005-02-13","18:41:59.985","=C8-INT(C8)",null,null,null,null,"David","2005-02-13T18:41:59.985"]
[null,"Leslie","2006-04-16T20:47:59.980","2006-04-16","20:47:59.980","=C9-INT(C9)",null,null,null,null,"Leslie","2006-04-16T20:47:59.980"]
[null,"Hulk","2007-06-17T22:53:59.975","2007-06-17","22:53:59.975","=C10-INT(C10)",null,null,null,null,"Hulk","2007-06-17T22:53:59.975"]
[null,"Michael","2008-08-18T01:43:00","2008-08-18","01:43:00","=C11-INT(C11)",null,null,null,null,"Michael","2008-08-18T01:43:00"]

{"sheet":"INT_Age","index":6,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,12]]}
[]
[null,"Calculate Age Using INT Function",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Name","Birth Date","Age (in Years)","Formula",null,null,null,null,null,"Name","Birth Date","Age (in Years)"]
[null,"Bred","2001-08-12",{"$f":"INT(YEARFRAC(C5,TODAY()))","v":21},{"$f":"_xlfn.FORMULATEXT(D5)","v":"=INT(YEARFRAC(C5,TODAY()))"},null,null,null,null,null,"Bred","2001-08-12"]
[null,"Olivia","2002-10-13",{"$f":"INT(YEARFRAC(C6,TODAY()))","v":20},{"$f":"_xlfn.FORMULATEXT(D6)","v":"=INT(YEARFRAC(C6,TODAY()))"},null,null,null,null,null,"Olivia","2002-10-13"]
[null,"James","2003-12-14",18,"=INT(YEARFRAC(C7,TODAY()))",null,null,null,null,null,"James","2003-12-14"]
[null,"David","2005-02-13",17,"=INT(YEARFRAC(C8,TODAY()))",null,null,null,null,null,"David","2005-02-13"]
[null,"Leslie","2006-04-16",16,"=INT(YEARFRAC(C9,TODAY()))",null,null,null,null,null,"Leslie","2006-04-16"]
[null,"Hulk","2007-06-17",15,"=INT(YEARFRAC(C10,TODAY()))",null,null,null,null,null,"Hulk","2007-06-17"]
[null,"Michael","2008-08-18",14,"=INT(YEARFRAC(C11,TODAY()))",null,null,null,null,null,"Michael","2008-08-18"]

{"sheet":"INT with IF","index":7,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,12]]}
[]
[null,"INT Function with IF Function",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Name","Weight","Decimal Value","Formula",null,null,null,null,null,"Name","Weight","Decimal Value"]
[null,"Bred",50,{"$f":"IF(C5>INT(C5),\"Is not Integer\", \"Is Integer\")","v":"Is Integer"},{"$f":"_xlfn.FORMULATEXT(D5)","v":"=IF(C5>INT(C5),\"Is not Integer\", \"Is Integer\")"},null,null,null,null,null,"Bred",50]
[null,"Olivia",30.91,{"$f":"IF(C6>INT(C6),\"Is not Integer\", \"Is Integer\")","v":"Is not Integer"},{"$f":"_xlfn.FORMULATEXT(D6)","v":"=IF(C6>INT(C6),\"Is not Integer\", \"Is Integer\")"},null,null,null,null,null,"Olivia",30.91]
[null,"James",40.51,"Is not Integer","=IF(C7>INT(C7),\"Is not Integer\", \"Is Integer\")",null,null,null,null,null,"James",40.51]
[null,"David",29,"Is Integer","=IF(C8>INT(C8),\"Is not Integer\", \"Is Integer\")",null,null,null,null,null,"David",29]
[null,"Leslie",78.41,"Is not Integer","=IF(C9>INT(C9),\"Is not Integer\", \"Is Integer\")",null,null,null,null,null,"Leslie",78.41]
[null,"Hulk",80.52,"Is not Integer","=IF(C10>INT(C10),\"Is not Integer\", \"Is Integer\")",null,null,null,null,null,"Hulk",80.52]
[null,"Michael",62,"Is Integer","=IF(C11>INT(C11),\"Is not Integer\", \"Is Integer\")",null,null,null,null,null,"Michael",62]

{"sheet":"INT VBA","index":8,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"INT Function Using VBA",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Name","Actual Weight","Rounded Weight",null,null,null,null,null,null,"Name","Actual Weight","Rounded Weight"]
[null,"Bred",50.78,50,null,null,null,null,null,null,"Bred",50.78]
[null,"Olivia",30.91,30,null,null,null,null,null,null,"Olivia",30.91]
[null,"James",40.51,40,null,null,null,null,null,null,"James",40.51]
[null,"David",29.2,29,null,null,null,null,null,null,"David",29.2]
[null,"Leslie",78.41,78,null,null,null,null,null,null,"Leslie",78.41]
[null,"Hulk",80.52,80,null,null,null,null,null,null,"Hulk",80.52]
[null,"Michael",62.12,62,null,null,null,null,null,null,"Michael",62.12]

{"sheet":"INT_RoundUp","index":9,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,12]]}
[]
[null,"Use of INT Function to Round Up",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Name","Actual Weight","Rounded Weight","Formula",null,null,null,null,null,"Name","Actual Weight","Rounded Weight"]
[null,"Bred",50.78,{"$f":"-INT(-C5)","v":51},{"$f":"_xlfn.FORMULATEXT(D5)","v":"=-INT(-C5)"},null,null,null,null,null,"Bred",50.78]
[null,"Olivia",30.91,{"$f":"-INT(-C6)","v":31},{"$f":"_xlfn.FORMULATEXT(D6)","v":"=-INT(-C6)"},null,null,null,null,null,"Olivia",30.91]
[null,"James",40.51,41,"=-INT(-C7)",null,null,null,null,null,"James",40.51]
[null,"David",29.2,30,"=-INT(-C8)",null,null,null,null,null,"David",29.2]
[null,"Leslie",78.41,79,"=-INT(-C9)",null,null,null,null,null,"Leslie",78.41]
[null,"Hulk",80.52,81,"=-INT(-C10)",null,null,null,null,null,"Hulk",80.52]
[null,"Michael",62.12,63,"=-INT(-C11)",null,null,null,null,null,"Michael",62.12]