📏 Precision Control

Goal: Round the number 3.7 to zero decimal places.
Compare how different rounding functions handle the same number.

3
4
3.7
Ready...

💻 Formula Structure

=ROUND(number, num_digits)
  • 1. Number: The decimal to round (3.7).
  • 2. Digits: 0 = Whole Number, 1 = One Decimal, 2 = Two Decimals.
-- Standard Rounding (Nearest)
=ROUND( 3.7, 0 )
Final Integer:
-

⚠️ Common Pitfalls

🚫 Formatting vs Rounding
Using the "Decrease Decimal" button only hides decimals visually. The math underneath is still precise. ROUND permanently changes the value.
🚫 Negative Digits
You can use -1 to round to the nearest 10, or -2 for nearest 100. (e.g. ROUND(123, -1) = 120).