From the course: Excel 2016: Advanced Formulas and Functions
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Working with MROUND, CEILING, and FLOOR for specialized rounding
From the course: Excel 2016: Advanced Formulas and Functions
Working with MROUND, CEILING, and FLOOR for specialized rounding
- In addition to standardized rounding techniques, we also have available some specialized rounding techniques called MROUND, CEILING and FLOOR. In column C, we currently see the ROUND function being used here to round numbers to the nearest two decimal places. Instead of that, consider the idea that maybe we want these new prices to be multiples of five cents or three cents or some other unusual combination. If we want to use rounding based on non-decimally oriented numbers, we'll use a function called MROUND. MROUND allows us to round, for example to the nearest five cents, .05. Now the answer here didn't change, although it certainly could. And you could imagine as I start to drag this downward what some of these entries will be. 3.25, this is going down to 4.25. That one probably will stay the same. And so on. Sometimes you might want to compare these with the original numbers. If we want to go upward, the function is not MROUNDUP, but CEILING instead. This will go to the next…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
Working with the ROUND, ROUNDUP, and ROUNDDOWN functions6m 13s
-
Working with MROUND, CEILING, and FLOOR for specialized rounding3m 20s
-
Using the INT and TRUNC functions to extract integer data3m 58s
-
Finding the remainder with MOD and using MOD with conditional formatting5m 26s
-
Exploring practical uses for the RAND and RANDBETWEEN functions4m 57s
-
Converting a value between measurement systems with CONVERT2m 55s
-
Using the powerful AGGREGATE function to bypass errors and hidden data6m 32s
-
Using the ROMAN and ARABIC functions to display different number systems3m 25s
-
-
-
-
-
-
-