Applies ToSharePoint Server Subscription Edition SharePoint Server 2019 SharePoint Server 2016 SharePoint Server 2013 SharePoint Server 2013 Enterprise SharePoint in Microsoft 365 SharePoint Foundation 2010 SharePoint Server 2010 SharePoint in Microsoft 365 Small Business Windows SharePoint Services 3.0

Returns number rounded up to the nearest odd integer.

Syntax

ODD(number)

Number     is the value to round.

Remarks

  • If number is nonnumeric, ODD returns the #VALUE! error value.

  • Regardless of the sign of number, a value is rounded up when adjusted away from zero. If number is an odd integer, no rounding occurs.

Examples

Formula

Description (Result)

=ODD(1.5)

Rounds 1.5 up to the nearest odd integer (3)

=ODD(3)

Rounds 3 up to the nearest odd integer (3)

=ODD(2)

Rounds 2 up to the nearest odd integer (3)

=ODD(-1)

Rounds -1 up to the nearest odd integer (-1)

=ODD(-2)

Rounds -2 up to the nearest odd integer (-3)

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.