Zoho Sheet ODD: Round to Odd Integers and Build Centered Windows

• Introduced: Original introduction release and date are not established by the checked sources.
• Availability: Currently documented in Zoho Sheet’s rolling web-service help; no retirement endpoint is established.
• Scope: English web-service documentation. Exact mobile and offline-client parity is unverified.
• Checked: October 14, 2026, against the official ODD reference. Documentation and independent rational calculations; no native Zoho Sheet test.

=ODD(number)

The number is required. No additional decimal-place, multiple or sign-mode parameter is documented. For the noninteger inputs in this guide, choose the smallest odd magnitude at least as large as the input magnitude, then retain the input’s sign.

For example, -5.3 has magnitude 5.3. Five is too small, so the next eligible magnitude is seven and the signed answer is -7. Rounding toward positive infinity would give a different result.

The reference’s three exact examples do not establish zero, already-odd inputs, omitted arguments or arbitrary type coercion. In particular, the zero case cannot be resolved merely by saying “keep the sign.” This guide leaves those boundaries explicitly unverified rather than importing another product’s result.

Create OddCases, with Input, Odd result and Change in A1:C1. Enter these numbers, then put =ODD(A2) in B2 and =B2-A2 in C2. Fill B2:C2 through row 9.

Rows 2–4 reproduce all three source examples. The other rows are independently calculated signed controls. Each B result is odd; the direction is away from zero for either sign.

In E2 enter =(B2-1)/2 and fill through E9. Expect 1,0,-4,2,-3,4,-5,4. Every odd integer can be written as twice an integer plus one, including negative odd integers. This is an arithmetic check of the outputs, not a separate native parity test.

In G2 enter =ROUNDUP(A2;0) and fill through G9. This uses the ROUNDUP reference’s semicolon argument separator; follow your sheet’s configured separator if needed.

Expect 3,1,-6,5,-5,9,-9,8. ROUNDUP targets any integer away from zero, while ODD requires an odd integer. At -5.3 the outcomes are -6 and -7; at 7.2 they are 8 and 9. Matching answers on a few other rows do not make the functions interchangeable.

Create CenteredWindows with Requested width, Odd width, Each side, Reconstructed width and Extra width in A1:E1. These are illustrative positive width requirements before choosing whole-cell dimensions.

Enter =ODD(A2) in B2, =(B2-1)/2 in C2, =2*C2+1 in D2 and =B2-A2 in E2. Fill B2:E2 through row 5.

C gives the number of positions on each side of one centre position. For the seven-cell window in row 4, three left positions plus one centre plus three right positions reconstruct seven. This does not construct a range or calculate a moving average; it only determines a valid symmetric width.

In G2 enter =SUM(B2:B5) for 24 and in G3 enter =SUM(A2:A5) for 21.7. In G4 use =G2-G3 for 2.3, matching =SUM(E2:E5) in G5. All four separate widths meet their own requirements.

Put numeric 10.1 in H2. In H3 enter =ODD(H2) for 11, and in H4 enter =(H3-1)/2 for 5. This independent control leaves the four original rows unchanged. Choosing an odd width does not establish whether that width is appropriate for a scientific or operational analysis.

Keep width requirements positive for this example; a negative odd result is a mathematical output, not a usable number of cells. Zoho’s generic error list is not a complete per-argument test matrix. No exact malformed-call, blank, numeric-text, Boolean, overflow or zero result is claimed here.

EVEN targets the other parity. ROUNDUP uses a decimal-place argument, ROUNDDOWN moves toward zero, and SUM reconciles the separate numeric widths. A similarly named function in another spreadsheet does not establish matching native edge cases or export behavior.