{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Contents","Introduction Round","Whole Number","Two Decimal","Round 10-100-1000","Round-RoundUP-RoundDown","ROUND Multiplies","RoundDOWN Presentage","Other ROUND Function","Rounddown-FLOOR"],"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":[]}
["ROUNDDOWN Function"]
[null,"automateexcel.com/functions/rounddown-formula-excel"]
[]
[null,"Table of Contents",null,null,null,"Other Resources"]
[null,"Introduction Round",null,null,null,"Excel Formulas w/Examples"]
[null,"Whole Number",null,null,null,"Excel Boot Camp - Learn Excel inside Excel"]
[null,"Two Decimal",null,null,null,"Excel Functions & Formulas Tutorial"]
[null,"Round 10-100-1000"]
[null,"Round-RoundUP-RoundDown"]
[null,"ROUND Multiplies"]
[null,"RoundDOWN Presentage"]
[null,"Other ROUND Function"]
[null,"Rounddown-FLOOR"]
[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 Round","index":1,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ROUNDDOWN",null,"=ROUNDDOWN (number, num_digits)"]
[null,"The Excel ROUNDDOWN function returns a number rounded down to a given number of places."]
[]
[null,"Number","Digits","Result"]
[null,5154.4566999999997,3,{"$f":"ROUNDDOWN(B6,C6)","v":5154.4560000000001}]
[null,5154.4566999999997,2,5154.45]
[null,5154.4566999999997,1,5154.3999999999996]
[null,5154.4566999999997,0,5154]
[null,5154.4566999999997,-1,5150]
[null,5154.4566999999997,-2,5100]
[null,5154.4566999999997,-3,5000]
[]
[null,"automateexcel.com/functions/rounddown-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Whole Number","index":2,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Number","Result"]
[154.01,{"$f":"ROUNDDOWN(A2,0)","v":154}]
[154.5,{"$f":"ROUNDDOWN(A3,0)","v":154}]
[154.99,{"$f":"ROUNDDOWN(A4,0)","v":154}]
[]
[null,"automateexcel.com/functions/rounddown-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Two Decimal","index":3,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Number","Result"]
[154.01233999999999,{"$f":"ROUNDDOWN(A2,2)","v":154.01}]
[154.55555000000001,{"$f":"ROUNDDOWN(A3,2)","v":154.55000000000001}]
[154.45644999999999,{"$f":"ROUNDDOWN(A4,2)","v":154.44999999999999}]
[]
[null,"automateexcel.com/functions/rounddown-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Round 10-100-1000","index":4,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Number","Nearest_10","Nearest_100","Nearest_1000"]
[1234.56,{"$f":"ROUNDDOWN(A2,-1)","v":1230},{"$f":"ROUNDDOWN(A2,-2)","v":1200},{"$f":"ROUNDDOWN(A2,-3)","v":1000},null,"=ROUNDDOWN(A2,-2)"]
[5555.55,{"$f":"ROUNDDOWN(A3,-1)","v":5550},{"$f":"ROUNDDOWN(A3,-2)","v":5500},{"$f":"ROUNDDOWN(A3,-3)","v":5000}]
[9876.5400000000009,{"$f":"ROUNDDOWN(A4,-1)","v":9870},{"$f":"ROUNDDOWN(A4,-2)","v":9800},{"$f":"ROUNDDOWN(A4,-3)","v":9000}]
[null,null,null,null,null,"=ROUNDDOWN(A2,-3)"]
[]
[null,"automateexcel.com/functions/rounddown-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Round-RoundUP-RoundDown","index":5,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Number","ROUND_100","ROUNDUP_100","ROUNDDOWN_100"]
[1234,{"$f":"ROUND(A2,-2)","v":1200},{"$f":"ROUNDUP(A2,-2)","v":1300},{"$f":"ROUNDDOWN(A2,-2)","v":1200},null,"=ROUNDUP(A2,-2)"]
[5555,5600,{"$f":"ROUNDUP(A3,-2)","v":5600},5500]
[9876,9900,9900,9800]
[null,null,null,null,null,"=ROUNDDOWN(A2,-2)"]
[]
[null,"automateexcel.com/functions/rounddown-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"ROUND Multiplies","index":6,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Number","Result"]
[1234,{"$f":"ROUNDUP(A2,-3)","v":2000}]
[2345,3000]
[3456,4000]
[4567,5000]
[5678,6000]
[6789,7000]
[9500,10000]
[]
[null,"automateexcel.com/functions/rounddown-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"RoundDOWN Presentage","index":7,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Percentage","Result"]
[1,{"$f":"ROUNDDOWN(A2,2)","v":1}]
[0.87949999999999995,{"$f":"ROUNDDOWN(A3,2)","v":0.87}]
[0.67230000000000001,0.67]
[0.1234,0.12]
[1.55E-2,0.01]
[]
[null,"automateexcel.com/functions/rounddown-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Other ROUND Function","index":8,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Round Formulas"]
[]
[null,"Number","Answer","FORMULA"]
[null,5154.45,{"$f":"ROUND(B5,0)","v":5154},"=ROUND(B5,0)"]
[null,5154.45,{"$f":"ROUNDUP(B6,-4)","v":10000},"=ROUNDUP(B6,-4)"]
[null,5154.45,{"$f":"ROUNDDOWN(B7,-3)","v":5000},"=ROUNDUP(B7,-3)"]
[null,5154.45,{"$f":"TRUNC(B8,-3)","v":5000},"=TRUNC(B8,-3)"]
[null,5154.45,{"$f":"INT(B9)","v":5154},"=INT(B9)"]
[null,5154.45,{"$f":"FLOOR(B10,100)","v":5100},"=FLOOR(B10,77)"]
[null,5154.45,{"$f":"CEILING(B11,100)","v":5200},"=CEILING(B11,100)"]
[null,5154.45,{"$f":"MROUND(B12,100)","v":5200},"=MROUND(B12,100)"]
[]
[]
[null,"automateexcel.com/functions/rounddown-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Rounddown-FLOOR","index":9,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Number","Significance (multiple )","Answer"]
[154.54599999999999,0.01,{"$f":"FLOOR(A2,B2)","v":154.54}]
[154.54599999999999,1,{"$f":"FLOOR(A3,B3)","v":154}]
[154.54599999999999,5,150]
[154.54599999999999,10,150]
[154.54599999999999,100,100]
[]
[null,"automateexcel.com/functions/rounddown-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]