Applies ToPrenumerationsversion av SharePoint Server SharePoint Server 2019 SharePoint Server 2016 SharePoint Server 2013 SharePoint Server 2013 Enterprise SharePoint i Microsoft 365 SharePoint Foundation 2010 SharePoint Server 2010 SharePoint i Microsoft 365 Small Business Windows SharePoint Services 3.0

Rounds a number down to the nearest integer.

Syntax

INT(number)

Number     is the real number you want to round down to an integer.

Example 1

Formula

Description (Result)

=INT(8.9)

Rounds 8.9 down (8)

=INT(-8.9)

Rounds -8.9 down (-9)

Example 2

Col1

Formula

Description (Result)

19.5

=[Col1]-INT([Col1])

Returns the decimal part of a positive real number in Col1 (0.5)

Behöver du mer hjälp?

Vill du ha fler alternativ?

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.