Applies ToSharePoint Server Abonelik Sürümü SharePoint Server 2019 SharePoint Server 2016 SharePoint Server 2013 SharePoint Server 2013 Enterprise Microsoft 365’te SharePoint SharePoint Foundation 2010 SharePoint Server 2010 Microsoft 365 Küçük İşletme’de SharePoint 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)

Daha fazla yardıma mı ihtiyacınız var?

Daha fazla seçenek mi istiyorsunuz?

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.