Applies ToSharePoint Server 訂閱版本 SharePoint Server 2019 SharePoint Server 2016 SharePoint Server 2013 SharePoint Server 2013 企業版 Microsoft 365 中的 SharePoint SharePoint Foundation 2010 SharePoint Server 2010 Microsoft 365 小型企業版中的 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)

需要更多協助嗎?

想要其他選項嗎?

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.