Edit

Share via


Mod function

Applies to: Canvas apps Cards Copilot Studio Desktop flows Dataverse formula columns Model-driven apps Power Platform CLI Dataverse functions Power Pages

Returns the remainder of a division.

Description

The Mod function returns the remainder after a number is divided by a divisor.

The result has the same sign as the divisor.

Syntax

Mod( Number, Divisor )

  • Number - Required. Number to divide.
  • Divisor - Required. Number to divide by.

Examples

Formula Description Result
Mod(25, 4) The number that remains after dividing 25 by 4 1
Mod(25, -4) The number that remains after dividing 25 by -4 -3
Mod(-25, -4) The number that remains after dividing -25 by -4 -1
Mod(-25, 4) The number that remains after dividing -25 by 4 3