### Excel Cram Kit (Exam 1)

Cell References
Basic Calculations
Working with Dates
VLOOKUP
Excel Charts
Text files

# ROUND

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.

=ROUND(number, num_digits)

In the above situation, we wanted to round 5.6324...

=ROUND(5.6324, num_digits)

...to 2 decimal places.

=ROUND(5.6324, 2)

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.