{"text_format":"1","workbook":"xlsx","n_sheets":9,"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"],"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":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[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(B7)","v":50},{"$f":"_xlfn.FORMULATEXT(C7)","v":"=INT(B7)"},"Rounds down to 50"]
[null,30.91,{"$f":"INT(B8)","v":30},{"$f":"_xlfn.FORMULATEXT(C8)","v":"=INT(B8)"},"Rounds down to 30"]
[null,0.56000000000000005,0,"=INT(B9)","Rounds down to 0"]
[null,-0.78,-1,"=INT(B10)","Rounds down to more negative value (-1)"]
[null,-2.12,-3,"=INT(B11)","Rounds down to more negative value (-3)"]
[null,-10.51,-11,"=INT(B12)","Rounds down to more negative value (-11)"]
[null,"2001-08-12T12:24:00","2001-08-12","=INT(B13)","Splits date from date-time"]
[null,"abc",{"$error":"#VALUE!"},"=INT(B14)","Shows #VALUE! When text value is inserted as input"]

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

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

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

{"sheet":"INT_Decimal Serial Number","index":4,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"INT Function when the Serial Number has Decimal Value"]
[]
[null,"Name","Birth Date-Time","Birth Date-Time \n(in Serial Number)","Birth Date","Formula"]
[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,"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,"James","2003-12-14T16:35:59.990",37969.691666550927,"2003-12-14","=INT(D7)"]
[null,"David","2005-02-13T18:41:59.985",38396.779166493056,"2005-02-13","=INT(D8)"]
[null,"Leslie","2006-04-16T20:47:59.980",38823.866666435184,"2006-04-16","=INT(D9)"]
[null,"Hulk","2007-06-17T22:53:59.975",39250.954166377313,"2007-06-17","=INT(D10)"]
[null,"Michael","2008-08-18T00:59:59.970",39678.041666319441,"2008-08-18","=INT(D11)"]

{"sheet":"INT_Splitting Date-Time","index":5,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using INT Function to Split Date-Time"]
[]
[null,"Name","Birth Date-Time","Birth Date","Birth Time","Formula"]
[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,"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,"James","2003-12-14T16:35:59.990","2003-12-14","16:35:59.990","=C7-INT(C7)"]
[null,"David","2005-02-13T18:41:59.985","2005-02-13","18:41:59.985","=C8-INT(C8)"]
[null,"Leslie","2006-04-16T20:47:59.980","2006-04-16","20:47:59.980","=C9-INT(C9)"]
[null,"Hulk","2007-06-17T22:53:59.975","2007-06-17","22:53:59.975","=C10-INT(C10)"]
[null,"Michael","2008-08-18T01:43:00","2008-08-18","01:43:00","=C11-INT(C11)"]

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

{"sheet":"INT with IF","index":7,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"INT Function with IF Function"]
[]
[null,"Name","Weight","Decimal Value","Formula"]
[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,"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,"James",40.51,"Is not Integer","=IF(C7>INT(C7),\"Is not Integer\", \"Is Integer\")"]
[null,"David",29,"Is Integer","=IF(C8>INT(C8),\"Is not Integer\", \"Is Integer\")"]
[null,"Leslie",78.41,"Is not Integer","=IF(C9>INT(C9),\"Is not Integer\", \"Is Integer\")"]
[null,"Hulk",80.52,"Is not Integer","=IF(C10>INT(C10),\"Is not Integer\", \"Is Integer\")"]
[null,"Michael",62,"Is Integer","=IF(C11>INT(C11),\"Is not Integer\", \"Is Integer\")"]

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