=ROUND(number; places)

Zoho’s official reference uses the expression above. Brackets indicate optional arguments, not text to type. All formula examples use Zoho’s English help syntax with semicolon argument separators. Numeric displays may gain currency symbols or decimal places depending on cell formatting. Read the answer as a number unless the guide expressly says it is text. The formulas below use cell references relative to the stated table.

Prepare this eight-order practice data

1. Open a blank Zoho Sheet and paste the table below into cells A1:F9, using row 1 for its six headers. A CSV with these exact eight records is also included in this batch; import it at A1 if copying the table is inconvenient.
2. Check that cells in the Amount and Units columns are numeric, not text imported from a CSV. Keep the headers out of formula ranges unless the guide explicitly says otherwise.
3. Enter the formula in an unused result cell such as H2, away from the original records; do not place it inside its input range.
4. Check the expected output against the values in the table before substituting your business data. These expected outputs are independently calculated, not verified by running Zoho Sheet.

Main calculation

=ROUND(AVERAGE(D2:D9);1)

Expected result: 113.8. AVERAGE of the eight amounts is 113.75. At one decimal place it rounds to 113.8.

Check the cell range character by character. If your result is different, confirm the row numbers, number formatting and that your inputs match the sample before changing the formula. The numbers here are calculated independently from the table, not copied from an application screenshot.

Second practical example

=ROUND(AVERAGE(D2:D9);0)

Expected result: 114. At zero decimal places, the 113.75 mean rounds to the whole number 114.

This is a second, separately reasoned test case using the same named inputs. When working with another workbook, change the column references deliberately and keep comparison criteria or array dimensions aligned.

=ROUND(125/12;2)

Expected result: 10.42. For an example per-unit calculation, 125 divided by 12 is 10.41666…; rounding to two decimal places returns 10.42. If instead computing a final invoice, verify your accounting rules and any tax rounding requirements separately.

For formula composition, first confirm the simpler formula works, and only then add nested functions or criteria. The advanced formula must be entered in a different unused cell, e.g. H4, to keep it away from the source ranges.

Do not confuse ROUND with ROUNDUP (always away from zero for discarded digits) or ROUNDDOWN (toward zero); those produce different answers for 10.4166…. Rounding intermediate values can change a later grand total; prefer rounding where business rules require it. Zoho’s own reference shows =ROUND(-3.15/2;2) as -1.58, illustrating how halves are handled in that example. Cell display precision alone does not alter stored arithmetic values.

Typical formula failures to investigate: #NAME! can indicate a misspelled function or undefined name; #REF! suggests a broken range reference; #VALUE! can indicate a wrong argument type. These are documented as possible errors in Zoho’s function help, but the precise error for a specific imported cell was not native-tested here. Check the formula bar, source cell data types, and range sizes before deciding that the function is broken.

If a formula returns an unexpected blank or zero, compare the relevant input rows with the worked sample. Check mixed numeric/text imports, copy-pasted quotes, leading/trailing spaces, and whether the selected input cells were moved or renamed. Do not infer an application version limitation solely from one failed formula: confirm function availability and syntax in Zoho’s in-app formula assistant.

Excel and Zoho both support ROUND(number, places) conceptually, but Zoho’s official syntax writes a semicolon. Check tie and floating-point cases in target software when reproducing financial calculations.

Cross-software transfer: Excel, Google Sheets, and LibreOffice Calc also use the named function for ordinary numerical cases, but do not copy argument separators blindly: Zoho’s English help examples use semicolons (;). Syntax details, empty-cell behavior, handling of text and errors, and compatibility with exports can differ. Test a small verified dataset after migrating rather than assuming a Zoho formula will behave exactly like an Excel or Numbers one.

• ROUNDUP guide
• ROUNDDOWN guide
• AVERAGE guide
• SUM guide

• Zoho Sheet — function documentation
• Zoho Sheet — official function category
• Zoho Sheet — full function index

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

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