{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Contents","Introduction Round","Whole Number","Two Decimal","Round 10-100-1000","RoundUP Presentage","Round-RoundUP-RoundDown","ROUND Multiplies","Other ROUND Function","CEILING"],"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":[]}
["ROUNDUP Function"]
[null,"automateexcel.com/functions/roundup-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,"RoundUP Presentage"]
[null,"Round-RoundUP-RoundDown"]
[null,"ROUND Multiplies"]
[null,"Other ROUND Function"]
[null,"CEILING"]
[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,"ROUNDUP",null,"=ROUNDUP (number, num_digits)"]
[null,"The Excel ROUNDUP function returns a number rounded up to a given number of decimal places."]
[]
[null,"Number","Digits","Result"]
[null,5154.4566999999997,3,{"$f":"ROUNDUP(B6,C6)","v":5154.4570000000003}]
[null,5154.4566999999997,2,{"$f":"ROUNDUP(B7,C7)","v":5154.46}]
[null,5154.4566999999997,1,5154.5]
[null,5154.4566999999997,0,5155]
[null,5154.4566999999997,-1,5160]
[null,5154.4566999999997,-2,5200]
[null,5154.4566999999997,-3,6000]
[]
[null,"automateexcel.com/functions/roundup-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":"ROUNDUP(A2,0)","v":155}]
[154.5,155]
[154.99,155]
[]
[null,"automateexcel.com/functions/roundup-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":"ROUNDUP(A2,2)","v":154.01999999999998}]
[154.55555000000001,154.56]
[154.45644999999999,154.45999999999998]
[]
[null,"automateexcel.com/functions/roundup-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":"ROUNDUP(A2,-1)","v":1240},{"$f":"ROUNDUP(A2,-2)","v":1300},{"$f":"ROUNDUP(A2,-3)","v":2000},null,"=ROUNDUP(A2,-2)"]
[5555.55,5560,5600,6000]
[9876.5400000000009,9880,9900,10000]
[null,null,null,null,null,"=ROUNDUP(A2,-3)"]
[]
[null,"automateexcel.com/functions/roundup-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"RoundUP Presentage","index":5,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Percentage","Result"]
[1,{"$f":"ROUNDUP(A2,2)","v":1}]
[0.87949999999999995,0.88]
[0.67230000000000001,0.68]
[0.1234,0.13]
[1.55E-2,0.02]
[]
[null,"automateexcel.com/functions/roundup-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Round-RoundUP-RoundDown","index":6,"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/roundup-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"ROUND Multiplies","index":7,"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/roundup-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/roundup-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"CEILING","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":"CEILING(A2,B2)","v":154.55000000000001}]
[154.54599999999999,1,{"$f":"CEILING(A3,B3)","v":155}]
[154.54599999999999,5,155]
[154.54599999999999,10,160]
[154.54599999999999,100,200]
[]
[null,"automateexcel.com/functions/roundup-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]