Applies To„SharePoint Server“ prenumeruojamas leidimas „SharePoint Server 2019“ „SharePoint Server 2016“ „SharePoint Server 2013“ „SharePoint Server 2013 Enterprise“ „SharePoint“, esantis „Microsoft 365“ SharePoint Foundation 2010 „SharePoint Server 2010“ „SharePoint“, esantis „Microsoft 365 Small Business“ Windows SharePoint Services 3.0

Returns the remainder after number is divided by divisor. The result has the same sign as divisor.

Syntax

MOD(number,divisor)

Number     is the number for which you want to find the remainder.

Divisor     is the number by which you want to divide number.

Remarks

  • If divisor is 0, MOD returns the #DIV/0! error value.

  • The MOD function can be expressed in terms of the INT function:

    MOD(n, d) = n - d*INT(n/d)

Examples

Formula

Description (Result)

=MOD(3, 2)

Remainder of 3/2. (1)

=MOD(-3, 2)

Remainder of -3/2. The sign is the same as divisor. (1)

=MOD(3, -2)

Remainder of 3/-2. The sign is the same as divisor. (-1)

=MOD(-3, -2)

Remainder of -3/-2. The sign is the same as divisor. (-1)

Reikia daugiau pagalbos?

Norite daugiau parinkčių?

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.