Documentation/Calc Functions/ODD
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
Function name:
ODD
Category:
Mathematical
Summary:
Rounds a positive number up to the next odd integer and a negative number down to the next odd integer.
Syntax:
ODD(Number)
Returns:
Returns an integer value, that is the rounded version of the original number.
Arguments:
Number is a real number, or a reference to the cell containing that number, that is to be rounded.
- If Number is non-numeric, then ODD reports a #VALUE! error.
Additional details:
- Returns an odd integer whose sign is the same as that of Number. The value returned should have the minimum absolute value that is greater than or equal to the absolute value of Number.
- If Number is equal to 0, then ODD returns 0.
Examples:
| Formula | Description | Returns |
|---|---|---|
| =ODD(3.3) | Rounds up 3.3 to the next odd integer. | 5 |
| =ODD(D1) where D1 contains the number 1.9. | Rounds up 1.9 to the next odd integer. | 3 |
| =ODD(0) | Returns 1. | 1 |
| =ODD(−0.5) | Rounds down -0.5 to the next odd integer. | −1 |
| =ODD(−3.1) | Rounds down -5 to the next odd integer. | −5 |
Related LibreOffice functions:
ODF standard:
Related (or similar) Excel functions:
ODD