ODD in Excel: Round Away from Zero and Build Odd-Sized Layouts

• Introduced: First introduction version is not established by the official history reviewed.
• Availability: official help lists Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016.
• Checked: October 14, 2026; official ODD reference. Documentation and independently calculated examples; no native Excel execution or broader platform certification.

=ODD(number)

The numeric argument is required. Microsoft explicitly describes away-from-zero adjustment for both signs and a #VALUE! error for a nonnumeric argument. This is a parity rule, not ordinary rounding to the nearest whole number.

The signed examples below use English function names and decimal-point numbers. The dedicated reference’s listed examples do not pin the zero-input special case, so this guide does not claim a newly verified native ODD(0) result. The layout model below uses positive sizes.

Enter −4.2, −3, −0.2, 0.2, 3, 4.2 in A2:A7. Fill =ODD(A2) down.

Expected results are −5, −3, −1, 1, 3, 5. Negative values increase in magnitude when an adjustment is needed. The exact values −3 and 3 stay where they are.

A nearest-integer rule would round 4.2 to four, but ODD cannot return four because four is not odd. The requirement chooses the allowed set of outputs before the magnitude direction is applied.

=ODD(4.2)
=EVEN(4.2)
=ODD(-4.2)
=EVEN(-4.2)

Expected results are 5, 6, −5 and −6. Both functions move away from zero when needed, but they select different parity classes. Neither result is a count of decimal places.

See EVEN for paired-capacity examples. Choose parity from the model rather than substituting one function solely because its result is numerically close.

A fictional one-dimensional display needs a unique center position with equal numbers of positions on either side. For positive minimum sizes 1, 2, 3, 4, 8, use ODD to select capacities.

Expected capacities are 1, 3, 3, 5, 9. For a selected size n, the center’s one-based position is (n+1)/2, giving 1, 2, 2, 3, 5. The number of positions on each side is (n−1)/2, giving 0, 1, 1, 2, 4.

If D2 contains a requested positive size and E2 contains =ODD(D2), use =(E2+1)/2 for the center. This is a discrete layout model, not a claim about every image-processing or statistical window convention.

Two separate displays each require a minimum of four positions. Giving each an odd capacity requires five positions apiece, totaling 10:

=ODD(4)+ODD(4)

One combined display with a minimum of eight positions instead needs odd capacity 9 through =ODD(4+4). These results serve different requirements. Adding first changes the number of centers and the physical arrangement.

For the finite control −4.2, ODD returns −5 and ODD(ODD(−4.2)) also returns −5. An already allowed integer is a fixed point of the documented rule.

This check can catch an implementation that blindly adds one even after reaching an odd integer. It does not establish how every floating-point value near an odd boundary is represented in a native client.

Inspect the stored value, sign, requested parity and units. Negative values are legitimate signed numeric controls but are invalid as physical position counts in this example. Keep zero handling, unusual type conversion and extreme magnitudes separately tested instead of inferring them from a few successful positive inputs.

• Microsoft ODD reference.
• Editorial testing standards.

Worked inputs are fictional. Decimal answers are independently calculated mathematical expectations rounded to nine places, not captured native results. Extreme magnitudes, complete coercion matrices and cross-version numerical accuracy remain untested.