Functions
ODD
Round up to nearest odd integer
Try it
When to use it
When should I use ODD?
Use ODD to round a value up to the nearest odd integer, for example when protocols or packaging requirements specify odd-numbered quantities.
Used in
Syntax
ODD(number)Examples
=ODD(2) // => 3
=ODD(-0.6) // => -1