Round any number to a chosen decimal place or whole number, with nearest, round-up, or round-down modes.
Round any number to a specified decimal place or significant figure, using nearest, round-up, or round-down modes — useful when you need consistent, predictable rounding behavior rather than relying on a spreadsheet's default rounding rules.
Example: 123.4567 rounded to 2 decimal places (nearest) gives 123.46 — switch the rounding mode above to see how "round up" or "round down" would differ.
"Nearest" rounds to the closest value (standard rounding). "Round Up" always rounds toward a larger value, and "Round Down" always rounds toward a smaller value, regardless of the digit that follows.
It supports "Nearest" (standard rounding to the closest value), "Round Up" (always rounds toward a larger value), and "Round Down" (always rounds toward a smaller value).
"Nearest" rounds to the closest value, which is the standard rounding method most people are familiar with.
"Round Up" always rounds toward a larger value regardless of the digit that follows, unlike "Nearest" which rounds based on which value is closer.
You can round any number to a chosen decimal place or to a whole number.
No — "Round Down" always truncates toward zero, regardless of how close the discarded digits are to rounding up. Use "Round" instead if you want standard rounding behavior.