Comments on: How to Round Numbers in Google Sheets (Easy Formulas) https://spreadsheetpoint.com/round-numbers-in-google-sheets/ Google Sheets Tips & Tutorials Wed, 27 Jul 2022 19:29:50 +0000 hourly 1 https://wordpress.org/?v=6.7.1 By: Christopher Daniel https://spreadsheetpoint.com/round-numbers-in-google-sheets/#comment-8554 Thu, 10 Feb 2022 13:50:15 +0000 https://spreadsheetpoint.com/?p=2575#comment-8554 In reply to Richard.

Yes, we’re glad you picked up on that. I’ve fixed it 🙂

]]> By: Richard https://spreadsheetpoint.com/round-numbers-in-google-sheets/#comment-6015 Mon, 23 Aug 2021 22:50:59 +0000 https://spreadsheetpoint.com/?p=2575#comment-6015 I think your explanation of rounding has the terms ’rounded up’ and ’rounded down’ reversed. You said:

The ROUND function takes a numeric value and rounds it to a specified number of decimal places, according to standard rules.

The standard rules of rounding are as follows:

If the digit to the right of the digit to be rounded is less than five, then it remains unchanged. In the other words, the number is ‘rounded up’ to the nearest digit
If the digit to the right of the digit to be rounded is greater than or equal to 5, then it is incremented by 1. In other words, the number is ‘rounded down’ to the nearest digit.

]]>