Excel Function

MOD

Returns remainder after division.

MOD(number, divisor)

Arguments

number

Required

Specify a single cell reference.

divisor

Required

Enter a numeric value.

Practice Preview

display numeric calculation results. Use MOD to Returns remainder after division. use 3 for divisor. Fill the argument fields below and complete a formula that achieves this goal.

Sample correct formula

=MOD(D2, 3)

Practice This Function

Practice in Sequential Mode Back to Function List