Rounds a number up to the nearest odd integer.
Składnia
ODD(number)Argumenty
numberwymagane
The value you want to round.
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)→3Rounds 1.5 up to the nearest odd integer, which is 3.
=ODD(-2)→-3Rounds -2 away from zero to the nearest odd integer, which is -3.
Select a cell
Click on the cell where you want to display the result.
Enter the formula
Type =ODD(number) and replace 'number' with your desired value or cell reference.
Press Enter
Press Enter to calculate the nearest odd integer.
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.