=ROUND(num-to-round, digits)

The placeholder names and ordering above follow Apple’s ROUND reference, checked 2026-10-10 America/Toronto (2026-10-11 UTC). Apple’s English examples use comma-separated arguments. If input parsing differs for your locale, use the in-app function browser to insert the function and select ranges instead of guessing separators.

In Numbers, create a new table named Example. Put the headings in row 1, add the following exact data in the corresponding row numbers, and enter the formula in an empty result cell outside the source ranges.

=ROUND(B2,2)

Expected output: 14.28.

How to check the result: 14.276 is closer to 14.28 than 14.27, so rounding to two decimals produces 14.28.

With the same data table, enter:

=ROUND(B6,-2)

Expected output: 1100.

With digits = -2, the result is rounded to the nearest hundred: 1111.222 becomes 1100.

For formulas in a different table, let the Numbers formula editor insert the correct cross-table references; do not blindly paste Excel sheet syntax into a Numbers document.

Formatting a cell to display two decimal places is not the same as changing the underlying value with ROUND. Rounding individual line items before summing can give a different total from rounding the final sum. Apple requires both arguments; do not assume Excel’s omitted-digits behavior carries over.

If you see too many decimals, distinguish formula output from cell display format. If the magnitude is unexpected, check whether digits is positive or negative. For always-up or always-down business rules, compare ROUNDUP and ROUNDDOWN instead.

If an input is absent or text where a numeric value is required, check the cell’s actual value type, not only its visual number format. Remove downstream error-handling wrappers temporarily when diagnosing a hidden calculation problem.

Apple documents these named functions in the shared Formulas and Functions Help, accessible when using Numbers and other iWork table editors. This source check confirms the syntax in the documentation available on the check date, not a specific minimum release version. The checked pages did not establish an introductory app version or a macOS-versus-iOS formula difference for this function; do not claim historical or device-specific parity without testing the actual installed versions. Entry workflow and localised punctuation may differ, so follow the platform’s Functions Browser if typing directly fails.

Excel, Google Sheets and LibreOffice Calc support ROUND, but verify negative midpoint conventions and locale separators before reusing financial calculations across applications.

• SUMIFS in Apple Numbers

• Apple Numbers — function documentation
• Formulas and Functions Help
• Apple — Functions by category

Verification status: Official documentation checked; example outcomes were independently reasoned or arithmetically checked where applicable. Not executed in Apple Numbers.

• No genuine Apple Numbers screenshots are included; this guide does not use mock application images.