# Documentation/Calc Functions/ODD

Jump to navigation
Jump to search

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 nearest odd integer and a negative number down to the nearest odd integer.

## Syntax:

ODD(**Number**)

## Returns:

Returns **Number** rounded to the next odd integer up, away from zero.

## Arguments:

**Number** is a real number or a reference to the cell containing that number whose odd rounded up/down value is to be calculated.

## Additional details:

None

## Examples:

Formula | Description | Returns |
---|---|---|

=ODD(2.3) | rounds up 2.3 to the nearest odd integer | 3 |

=ODD(2) | rounds up 2 to the nearest odd integer | 3 |

=ODD(0) | rounds up 0 to the nearest odd integer | 1 |

=ODD(-0.5) | rounds down -0.5 to the nearest odd integer | -1 |

=ODD(-3.1) | rounds down -5 to the nearest odd integer | -5 |

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

ODD