Simply put, the ROUND function enables us to round numbers. That's it.
So if we had the following number:
I could round it to 2 decimal places using the ROUND function:
The ROUND function allows us to round a given number to a specific decimal place.
Coding a ROUND function
Let's first check out the ROUND function template, and then apply it.
In the above situation, we wanted to round 5.6324...
...to 2 decimal places.
When we plug this into Excel, we get the same output as we got on the calculator!
It's important to remember...
The num_digits argument doesn't represent the total number of digits, it represents the number of digits after the decimal point!
For example, if we wanted to round to a whole number, all we'd need to do is place a "0" as the second argument, signifying we want 0 digits after the decimal point.
Round the number 17.91635 to 3 decimal places.
Next, let's learn the difference between the WEEKDAY and WORKDAY functions and how we can use them.
Excel Cram Kit (Exam 1)
Want to unlock content? Get your Excel Cram Kit (Exam 1) now!
|Apply||PRACTICE EXCEL EXAM 1 (PREVIEW ONLY)|
|Tools||Excel Nerd Notes (Exam 1) (PREVIEW ONLY)|
|Lesson||YEAR, MONTH, DAY|
|Lesson||SUM & AutoSUM|
|Lesson||Relative vs. Absolute Cell References|
|Lesson||WEEKDAY vs. WORKDAY (PREVIEW ONLY)|
|Lesson||VLOOKUP (PREVIEW ONLY)|
|Lesson||PMT (PREVIEW ONLY)|
|Lesson||IF (PREVIEW ONLY)|
|Lesson||Percent change (PREVIEW ONLY)|
|Lesson||Excel charts (PREVIEW ONLY)|
|Lesson||Importing text files (PREVIEW ONLY)|
Excel Reviews (Exam 1)
"I bought this Cram Kit the night before my exam, and it helped me tremendously. It provides step-by-step explanations for all the units covered in class."
Oct. 14, 2021