Rounds a number up to the nearest odd integer.
Diese Funktion funktioniert in Google Sheets genauso wie in Excel — gleiche Syntax und Argumente.
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)Ergebnis: 3
Rounds 1.5 up to the nearest odd integer, which is 3.
=ODD(-2)Ergebnis: -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.