From the course: Excel: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

MROUND, CEILING, and FLOOR

MROUND, CEILING, and FLOOR

From the course: Excel: Advanced Formulas and Functions

Start my 1-month free trial Buy for my team

MROUND, CEILING, and FLOOR

“

- [Instructor] Let's look at a certain type of rounding that involves significance. In the Cost column, we have the actual cost of several items, and it's going out a lot of decimal places, and we want to, ultimately, get to prices that would look decent on a menu. 'Cause $3.19, no. We need to be at 3.25, $3 even, 2.99, something! Okay, so let's get started here. We want to include our markup. Equals, the cost times the markup, and hit F4 so that we lock the markup rate in place. Okay, Enter. There we go with the markup. Now MRound. Equals, MRound, open parenthesis, our number here, comma, the multiple are the significance, Select the 0.65, hit F4 to lock that in place, and Enter. Now every price is at a multiple of 0.65. We can change it. What if we want 0.55? All right, so now we have something that would be $190.85. Okay, let's go to Ceiling and Floor. Equals, Ceiling, and I'm going to choose Ceiling…

Contents