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

Working with MROUND, CEILING, and FLOOR for specialized rounding

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

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…

Contents