When you use the Round function, typically you're dealing with rounding …numbers based on decimal placement. For example, in this worksheet called …SpecializedRounding, in column C, we've got formulas, and in C2 we see the …formula here that's rounding a calculation to the nearest two decimal places. …In other words, to the nearest penny. Now, we also could round this if we …wanted to to the nearest dollar. We probably wouldn't do that with pricing …items like the ones in column B but we could do that. …But the numbers that we use here in the final portion of the Round function to …the number of decimal places. What if we wanted to round this to a …multiple or a different number not related to decimals.…

What if we wanted to round all of our prices to the nearest nickel, for example? …We can't just plug in a 0.05 there. We need to use a different function …called MROUND. We now want to round this to the nearest …5 cents, the nearest nickel, you might say, 0.05. …Now, the example in our first case here, since the price was $9, it's going to …

Resume Transcript Auto-Scroll

Author

Released

5/16/2013

Conquer some of the most daunting features in Microsoft Excel once and for all. In this 2013 update to his popular series, author Dennis Taylor demystifies some of the most challenging of the 300+ formulas and functions in Excel and shows how to put them to their best use. The course starts with a review of the more basic, building-block functions, and a few critical keyboard shortcuts that will speed up working with Excel data, even on multiple sheets. Dennis then covers how to perform advanced searching and data retrieval with Lookup functions, tabulate and sort data with counting and statistical functions, format data with text and math functions, and work with financial data using advanced formulas. Dennis focuses on practical examples that transition effortlessly to real-world scenarios.