Zoho Sheet FIXED Function: Decimal Text and Grouping Controls

Zoho’s official FIXED entry was retrieved on October 15, 2026. The entry documents the rolling web service; it does not establish the first introduction release or last functioning version. Both historical endpoints are unknown, and mobile/offline parity is unverified. The calculated expectations here are independent reference values, not captured native Zoho results.

FIXED(number; [decimals]; [omit_separators])

Number is required. Decimals defaults to 2. Omit_separators defaults to FALSE, which includes the thousands separator; TRUE excludes it. The flag describes omission, so its direction is easy to reverse accidentally.

To use the default precision while setting the third argument, preserve the empty middle position: =FIXED(12534.5;;TRUE). Its expected source-style text is 12534.50. Dropping that empty position would make TRUE occupy the decimal-places argument instead.

These examples use the English help’s comma grouping and decimal point. Separators and formula punctuation should be checked in the actual workbook locale. The help does not establish a complete cross-locale formatting matrix, negative precision behavior, fractional precision coercion or a halfway-rounding rule.

The official page uses cell references for its three outputs. With fully specified inputs, the following controls reproduce their displayed representations:

These are independent reconstructed inputs, not a claim to have read the vendor’s embedded cells. Every value already has enough specified precision that no halfway choice is involved.

Create DisplayValues with Number in A1, Decimals in B1, Grouped_text in C1 and Plain_text in D1. Enter A2:B6 as below. Fill C2 =FIXED(A2;B2;FALSE) and D2 =FIXED(A2;B2;TRUE) down to row 6.

Change B5 from 4 to 2 in a copy. Both display outputs become 7.00, while A5 remains the number 7. This makes the distinction between source value and display precision explicit.

Put numeric quantity 3 in G2 and numeric unit amount 12.5 in H2. In I2 enter =G2*H2, giving numeric 37.5. In J2 use ="Line amount: "&FIXED(I2;2;TRUE). The expected text is Line amount: 37.50.

Change G2 to 4. I2 becomes numeric 50, and the label becomes Line amount: 50.00. Keep I2 available for totals. Adding display strings is not a dependable replacement for summing the numeric source, especially when text includes grouping or other labels.

For numeric 1234.5, two output fields may legitimately require different representations: =FIXED(1234.5;1;TRUE) gives 1234.5, while =FIXED(1234.5;3;TRUE) gives 1234.500. They describe the same supplied quantity but satisfy different text-width contracts.

A decimal-place count is not a claim of measurement accuracy. Adding trailing zeroes does not improve an instrument reading, and formatting an approximate value does not make it exact. For an export, retain the unit and source precision as separate information when they matter.

The entry provides a shared name/type/reference error glossary but no function-specific numerical error table. Do not invent a maximum precision or a rule for negative decimal counts from another spreadsheet product. Use ordinary numeric inputs and explicit nonnegative integer precisions for these controls.

If grouping appears when it should be absent, check the third argument’s direction. If a third-argument-only formula behaves unexpectedly, check the empty middle position. If a total stops behaving numerically, inspect whether FIXED’s text output replaced the raw numeric field.

For plain cell display without a text result, consider a number format on the numeric cell instead. FIXED is appropriate when a downstream label or text export actually needs a formatted string. No native export, locale conversion or spreadsheet execution was performed.