Excel MOD function

Function              MOD

Description        Excel MOD function returns the remainder when a number is divided by a given divisor.

Syntax  MOD(number, divisor)

number  The number to be divided.

divisor  The number to divide with.

Example:

=MOD(13,10)= 3

=MOD(23.5,1)= 0.5

=MOD(23.5,5)= 3.5

Related Video Tutorials: