이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
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)결과: 3
Rounds 1.5 up to the nearest odd integer, which is 3.
=ODD(-2)결과: -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.