{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Overview","Remove decimals","shorten number","Date and time","VBA","Alternative"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Overview","index":0,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["Excel TRUNC Function"]
[null,"truncates a number to an integer by removing the decimal, or fractional, part of the number."]
[null,"=TRUNC(number,[num_digits])"]
[]
[null,"Number","Digits","Result","Formula","Explanation"]
[null,24.423999999999999,null,{"$f":"TRUNC(B6)","v":24},{"$f":"_xlfn.FORMULATEXT(D6)","v":"=TRUNC(B6)"},"truncates the decimal part"]
[null,38.869999999999997,null,{"$f":"TRUNC(B7)","v":38},{"$f":"_xlfn.FORMULATEXT(D7)","v":"=TRUNC(B7)"},"doesn't round the number"]
[null,9.81,1,{"$f":"TRUNC(B8,C8)","v":9.8000000000000007},"=TRUNC(B8,C8)","truncates to 1 decimal point"]
[null,3.1415929999999999,2,3.14,"=TRUNC(B9,C9)","truncates to 2 decimal point"]
[null,0.56699999999999995,1,0.5,"=TRUNC(B10,C10)","truncates a number  between 0 to 1 to 1 decimal point"]
[null,0.45300000000000001,null,0,{"$f":"_xlfn.FORMULATEXT(D11)","v":"=TRUNC(B11,C11)"},"truncates a number  between 0 to 1 and return 0"]
[null,858,-1,850,"=TRUNC(B12,C12)","eliminates an integer digit "]
[null,845.78,-1,840,"=TRUNC(B13,C13)","eliminates an integer digit and truncates the decimal part"]
[null,-45.67,0,-45,"=TRUNC(B14,C14)","truncates a negative number and gives the integer part"]
[null,"2020-10-25T12:50:00",null,{"$f":"TRUNC(B15)","v":"2020-10-25"},{"$f":"_xlfn.FORMULATEXT(D15)","v":"=TRUNC(B15)"},"extracts date from a date and time"]

{"sheet":"Remove decimals","index":1,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Excel TRUNC Function"]
[]
[]
[null,"Number","Interger"]
[null,24.423999999999999,{"$f":"TRUNC(B5)","v":24}]
[null,38.869999999999997,{"$f":"TRUNC(B6)","v":38}]
[null,9.81,9]
[null,3.1415929999999999,3]
[null,0.56699999999999995,0]
[null,0.45300000000000001,0]

{"sheet":"shorten number","index":2,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Excel TRUNC Function"]
[]
[]
[null,"Number","Digits","Result"]
[null,9.81,1,{"$f":"TRUNC(B5,C5)","v":9.8000000000000007}]
[null,3.1415929999999999,2,{"$f":"TRUNC(B6,C6)","v":3.14}]
[null,0.56699999999999995,1,0.5]
[null,858,-1,850]
[null,845.78,-2,800]
[null,-45.67,1,-45.6]

{"sheet":"Date and time","index":3,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Excel TRUNC Function"]
[]
[]
[null,"Date and Time","Date"]
[null,"2018-12-15T00:56:00",{"$f":"TRUNC(B5)","v":"2018-12-15"}]
[null,"2020-08-22T01:36:00",{"$f":"TRUNC(B6)","v":"2020-08-22"}]
[null,"2019-05-17T04:56:00","2019-05-17"]
[null,"2021-12-18T12:30:00","2021-12-18"]
[null,"2015-04-19T17:40:00","2015-04-19"]
[null,"2012-07-05T20:20:00","2012-07-05"]

{"sheet":"VBA","index":4,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Excel TRUNC Function"]
[]
[]
[null,"Number","Result"]
[null,24.423999999999999,24.42]
[null,12.4565,12.46]
[null,9.81,9.81]
[null,3.1415929999999999,3.14]
[null,0.56699999999999995,0.56999999999999995]
[null,0.45300000000000001,0.45]

{"sheet":"Alternative","index":5,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,2,2,3],[2,4,2,5],[2,6,2,7],[2,1,3,1],[0,0,0,7]]}
["Alternatives of Excel TRUNC Function"]
[]
[null,"Number","Excel INT Function",null,"Excel ROUND Function",null,"Excel ROUNDDOWN function"]
[null,null,"Result","Formula","Result","Formula","Result","Formula"]
[null,24.423999999999999,{"$f":"INT(B5)","v":24},{"$f":"_xlfn.FORMULATEXT(C5)","v":"=INT(B5)"},{"$f":"ROUND(B5,0)","v":24},{"$f":"_xlfn.FORMULATEXT(E5)","v":"=ROUND(B5,0)"},{"$f":"ROUNDDOWN(B5,0)","v":24},{"$f":"_xlfn.FORMULATEXT(G5)","v":"=ROUNDDOWN(B5,0)"}]
[null,38.869999999999997,{"$f":"INT(B6)","v":38},{"$f":"_xlfn.FORMULATEXT(C6)","v":"=INT(B6)"},{"$f":"ROUND(B6,0)","v":39},{"$f":"_xlfn.FORMULATEXT(E6)","v":"=ROUND(B6,0)"},{"$f":"ROUNDDOWN(B6,0)","v":38},{"$f":"_xlfn.FORMULATEXT(G6)","v":"=ROUNDDOWN(B6,0)"}]
[null,9.81,9,"=INT(B7)",10,"=ROUND(B7,0)",9,"=ROUNDDOWN(B7,0)"]
[null,3.1415929999999999,3,"=INT(B8)",3,"=ROUND(B8,0)",3,"=ROUNDDOWN(B8,0)"]
[null,0.56699999999999995,0,"=INT(B9)",1,"=ROUND(B9,0)",0,"=ROUNDDOWN(B9,0)"]
[null,0.45300000000000001,0,"=INT(B10)",0,"=ROUND(B10,0)",0,"=ROUNDDOWN(B10,0)"]