Odd

Syntax

Odd(Value)

Parameters

Value. Rounded value.

NOTE. To determine the parameter, specify either the number or the address of the cell where it is located.

Description

It returns the result of rounding the value to the nearest odd integer.

Example

Formula Result Description
=Odd(-1.7) -3 It rounds the -1.7 number to the nearest odd integer.
=Odd(B6) 3 It rounds the number in the B6 cell to the nearest odd integer. The B6 cell contains the 2.1 number.

See also:

Function Wizard │ Mathematical Functions │ Ceiling │ Even │ Floor │ Int │ MRound │ Round │ RoundDown │ RoundUp │ Trunc