ODD in Google Sheets: Signed Rounding and Centered Layouts

• Introduced: first service launch date is not established by the official history reviewed; no numbered desktop introduction is assigned.
• Availability: documented in the rolling Google Sheets service. Examples use ordinary web-spreadsheet numeric cells; other clients and imported files are not separately certified.
• Checked: October 14, 2026; official ODD reference. Documentation and independent calculations, without native Sheets execution.

=ODD(value)

Google explicitly describes negative values as rounding down to a negative odd integer with greater absolute value. Thus -5.4 goes toward -7, not toward -5. An already odd integer stays unchanged in the ordinary rounding model.

The worked examples avoid zero because the short reference does not state its convention explicitly. Complete text, Boolean, extreme-value and near-boundary behavior is also outside this documentation-and-calculation review. Do not copy a different spreadsheet product’s zero rule and label it verified Sheets behavior.

Enter these values in A2:A7 and fill =ODD(A2) down:

The output preserves the sign of these nonzero inputs. For comparison, EVEN(5.4) has expected result six and EVEN(-5.4) has expected result -6. The two functions target different integer sets, not different display styles.

ODD(2) has expected result three. It does not test whether two is odd or return a Boolean result.

Suppose a display needs at least 2, 3, 6 or 9 positions and must have one center. The expected adjusted odd sizes are 3, 3, 7 and 9.

With the required size in A2, calculate:

=ODD(A2)
=(ODD(A2)+1)/2
=(ODD(A2)-1)/2

These formulas give the total size, the one-based center position, and the count on each side. For the four inputs, the centers are 2, 2, 4 and 5, with 1, 1, 3 and 4 positions on each side.

This model needs a positive input. A negative signed rounding result is mathematically valid for the documented rule but is not a meaningful count of display positions.

For a required size of six, ODD returns seven. Number positions 1 through 7. Subtract the center index four from each position to obtain coordinates:

-3, -2, -1, 0, 1, 2, 3.

There is one zero coordinate and three positions on each side. The count is seven, while the distance from the leftmost to the rightmost coordinate is six units. Confusing a number of points with a number of gaps produces an off-by-one error even when the ODD formula is correct.

Two displays each require six positions:

=ODD(6)+ODD(6)
=ODD(6+6)

Expected results: 14 and 13. Separate displays each need their own center, so each receives seven positions. One pooled display only needs one center and can use 13.

The first total is even although both component sizes are odd. ODD’s name does not imply that every sum built from it will be odd. Choose the aggregation stage from the actual layout requirement rather than adjusting the total after the fact.

To test divisibility rather than change a size, use a separate whole-number rule such as =MOD(7,2)=1, with expected result TRUE for that positive control. MOD and ODD answer different questions.

The finite model is idempotent: ODD(-5.4) is -7 and ODD(-7) remains -7. If a repeated calculation appears to change the result, inspect the underlying input and formula references rather than relying on displayed rounding. Locale-dependent separators and imported formulas should be checked in the destination sheet.

• Google ODD help.
• Editorial testing standards.

Inputs are fictional. Approximate numerical answers are independently calculated mathematical expectations rounded to nine places, not captured native results. Complete coercion, extreme-magnitude and cross-client behavior remain untested.