Formualizer Docs
ReferenceFunctionsMath Functions

ODD

Rounds a number away from zero to the nearest odd integer.

Summary

Rounds a number away from zero to the nearest odd integer.

Remarks

  • Values already equal to an odd integer stay unchanged.
  • Positive and negative values both move away from zero.
  • 0 returns 1.

Examples

Round a positive number to odd
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
3
Round a negative number away from zero
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
-3

FAQ

Why does ODD(0) return 1?

ODD rounds away from zero to the nearest odd integer, so zero maps to positive one.

Runtime metadata

Category

Math

Signature

ODD(arg1: Number)

Arity

min 1, max 1

Arguments

arg1

Number · Scalar · coercion NumberLenientText

Caps

PURE

Source

crates/formualizer-eval/src/builtins/math/numeric.rs

MULTINOMIAL

Returns the multinomial coefficient for one or more values.

PERMUT

Returns the number of permutations for selecting and ordering `k` items from `n`.

On this page

SummaryRemarksExamplesRelated functionsFAQWhy does ODD(0) return 1?Runtime metadata