Function Type:
Math and Trigonometry
Description:
The ROUND function in Excel or Google Sheets is used to round a number to a specified number of digits (decimal places).
It is useful and frequently used combined with other functions.
I've personally used this function the other day for my freelance service to a client together with ROW and COLUMN functions since they both have to be whole numbers.
Function Structure:
=ROUND(number, num_digits)
Argument Breakdown:
number - The number that you want to round.
num_digits - The number of digits to which number should be rounded.
Example:
ROUND num_digits is greater than 0
If num_digits is greater than 0, then number is rounded to the specified number of decimal places.
Putting 3 on will result in rounding to 3 decimal places
result:
ROUND num_digits is 0
If num_digits is 0, then number is rounded to the nearest integer.
Putting 0 will result in having a whole number.
result:
ROUND num_digits is less than 0
If num_digits is less than 0, then 0s will be placed after the decimal place. See examples.
Putting -2 will result in rounding to the nearest hundreds.
result:
Still need help with Excel and Google Sheets?
Get Instant Expert Help in Fiverr or PeoplePerHour platforms. Click one icon below.
We can also accept LEO, HIVE, HBD tokens as payment if we transact directly here in HIVE network.
This post is designated as a reviewer for Excel trainings I conduct.
Feel free to share with anyone. 馃槈
Earnings from Upvotes on this post are used to continue sharing Excel knowledge.
If you also want to earn HIVE in 7 days while blogging your favorite topics, join us here at Peakd.
*Thumbnail used is made in Canva.