Rounds a number up to the nearest odd integer.
Cette fonction fonctionne de la même façon dans Google Sheets que dans Excel — même syntaxe et mêmes arguments.
ODD(number)The ODD function rounds a positive number away from zero and a negative number toward zero to the nearest odd integer. If the number is already an odd integer, no rounding occurs.
=ODD(1.5)Résultat : 3
Rounds 1.5 up to the nearest odd integer, which is 3.
=ODD(-2)Résultat : -3
Rounds -2 away from zero to the nearest odd integer, which is -3.
It rounds away from zero, meaning positive numbers are rounded up and negative numbers are rounded down.
If the number is already an odd integer, the function returns the number unchanged.