{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Contents","Introduction Round","Round-RoundUP-RoundDown","Mround-Floor-CEILING","CEILING-0.5-5-50 ","Round to Nearest Quarter"],"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":[]}
["CEILING Function"]
[null,"automateexcel.com/functions/ceiling-formula-excel"]
[]
[null,"Table of Contents",null,null,null,"Other Resources"]
[null,"Introduction Round",null,null,null,"Excel Formulas w/Examples"]
[null,"Round-RoundUP-RoundDown",null,null,null,"Excel Boot Camp - Learn Excel inside Excel"]
[null,"Mround-Floor-CEILING",null,null,null,"Excel Functions & Formulas Tutorial"]
[null,"CEILING-0.5-5-50 "]
[null,"Round to Nearest Quarter"]
[]
[]
[]
[null,"Excel Boot Camp"]
[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,"MROUND",null,"=MROUND (number, multiple)"]
[null,"The Excel MROUND function returns a number rounded to a given multiple. "]
[]
[null,"Number","Multiple","Result"]
[null,5154.4566999999997,0.01,{"$f":"MROUND(B6,C6)","v":5154.46}]
[null,5154.4566999999997,0.1,{"$f":"MROUND(B7,C7)","v":5154.5}]
[null,5154.4566999999997,1,5154]
[null,5154.4566999999997,5,5155]
[null,5154.4566999999997,10,5150]
[null,5154.4566999999997,100,5200]
[null,5154.4566999999997,1000,5000]
[]
[null,"automateexcel.com/functions/ceiling-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Round-RoundUP-RoundDown","index":2,"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,{"$f":"ROUND(A3,-2)","v":5600},{"$f":"ROUNDUP(A3,-2)","v":5600},5500]
[9876,9900,9900,9800]
[null,null,null,null,null,"=ROUNDDOWN(A2,-2)"]
[]
[null,"automateexcel.com/functions/ceiling-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Mround-Floor-CEILING","index":3,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Number","MROUND","FLOOR","CEILING"]
[null,120,{"$f":"MROUND(B3,5)","v":120},{"$f":"FLOOR(B3,5)","v":120},{"$f":"CEILING(B3,5)","v":120},null,"=FLOOR(B3,5)"]
[null,99,{"$f":"MROUND(B4,5)","v":100},{"$f":"FLOOR(B4,5)","v":95},{"$f":"CEILING(B4,5)","v":100}]
[null,259,260,255,260,null,"=CEILING(B3,5)"]
[null,272,270,270,275]
[null,120,120,120,120]
[]
[null,"automateexcel.com/functions/ceiling-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"CEILING-0.5-5-50 ","index":4,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Number","CEILING_0.5","CEILING_5","CEILING_50"]
[4.7,{"$f":"CEILING(A2,0.5)","v":5},{"$f":"CEILING(A2,5)","v":5},{"$f":"CEILING(A2,50)","v":50},null,"=CEILING(A2,5)"]
[47.3,{"$f":"CEILING(A3,0.5)","v":47.5},{"$f":"CEILING(A3,5)","v":50},{"$f":"CEILING(A3,50)","v":50}]
[99.6,{"$f":"CEILING(A4,0.5)","v":100},{"$f":"CEILING(A4,5)","v":100},{"$f":"CEILING(A4,50)","v":100}]
[175.1,{"$f":"CEILING(A5,0.5)","v":175.5},{"$f":"CEILING(A5,5)","v":180},{"$f":"CEILING(A5,50)","v":200},null,"=CEILING(A2,50)"]
[276,{"$f":"CEILING(A6,0.5)","v":276},{"$f":"CEILING(A6,5)","v":280},{"$f":"CEILING(A6,50)","v":300}]
[]
[null,"automateexcel.com/functions/ceiling-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Round to Nearest Quarter","index":5,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Number","Result"]
[123.53,{"$f":"CEILING(A2,0.25)","v":123.75}]
[]
[null,"automateexcel.com/functions/ceiling-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]