Mod Formula in MS Excel

 Mod Formula in MS Excel

The MOD formula in MS Excel returns the remainder of a division operation.

The syntax of the MOD formula is as follows:

MOD(number, divisor)

Where:

• number: The number to be divided.
• divisor: The number to divide by.

For example, the following formula would return the remainder of dividing the value in cell A1 by 3:

=MOD(A1, 3)

The MOD formula is useful for checking if a number is evenly divisible by another number, as the result will be zero if the division is exact. For example, the following formula would return TRUE if the value in cell A1 is divisible by 3, and FALSE otherwise:

=MOD(A1, 3)=0