Use the ROUND function to change the result of a formula or reference by rounding it to the nearest number of positions to the right of the decimal (a positive number) or to the left of the decimal (a negative number). Use ROUNDUP and ROUNDDOWN to round up (or down) to the next (not the nearest) value.
- [Voiceover] In the workbook 08-Math,…the first sheet is called Basic Rounding.…Rounding is an important feature in Excel…but it is often overlooked or misinterpreted.…In this worksheet, there is a formula in cell E2.…We're going to have a price increase based on the item in D2…We come up with an answer of nine dollars.…Now, just to test this out a little bit,…in cell F2, I'm going to write a formula…equal this amount times the number we see above it,…10,000 and you know immediately the answer should be…90,000, but its not 90,000 and somebody has to account…for this what, 43 dollars and 14 cents here.…
What's happening here?…Well as it turns out,…apparently that's not really nine dollars.…We can see clearly that's 10,000,…double click there, and well that's what we see…and here too, we'll double click but…we see a formula but what we're not seeing here…and sometimes you want to be careful about formulas…particularly if you're talking about pennies…and sometimes even dollars.…Is this truly the result the result of that function?…
Author
Dennis Taylor
Released
5/26/2016- Understanding how the hierarchy of operators affects formula results
- Knowing when to use absolute vs. relative references
- Using Formula Builder for unfamiliar functions
- Displaying a worksheet's formulas and highlighting formula cells
- Converting formulas to values
- Creating 3D formulas to gather data from multiple sheets
- Creating and expanding nested IF functions; using AND, OR, and NOT with IF
- Looking up information with VLOOKUP, HLOOKUP, MATCH, and INDEX
- Analyzing data with the statistical functions: MEDIAN, MODE, etc.
- Using the power functions: COUNTIF, SUMIF, COUNTIFS, AVERAGEIFS, and more
- Calculating financial data such as payments
- Performing basic math
- Calculating dates and times
- Editing text with functions
- Using array formulas and functions
- Referencing data in other cells and files
- Extracting information from Excel worksheets
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome50s
-
Exercise files25s
-
-
1. Formula and Function Tools
-
2. Formula and Function Tips and Shortcuts
-
3. IF and Related Functions
-
4. Lookup and Reference Functions
-
Use MATCH and INDEX together4m 40s
-
5. Statistical Functions
-
6. Power Functions
-
7. Selected Financial Functions
-
8. Math Functions
-
9. Date and Time Functions
-
10. Text Functions
-
11. Array Formulas and Functions
-
12. Reference Functions
-
13. Information Functions
-
Conclusion
-
Next steps25s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Change displayed result with ROUND, ROUNDUP, and ROUNDDOWN