# 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