Excel MOD Function

Excel MOD Function

Purpose 

Get the remainder from division

Return value 

The remainder

Syntax 

=MOD (number, divisor)

Arguments 

  • number – The number to be divided.
  • divisor – The number to divide with.

Usage notes 

Use the MOD function to get the reminder after division. For Example, MOD(3,2) returns 1, because 2 goes into 3 once, with a remainder of 1.

Notes:

  • MOD always returns a result in the same sign as the divisor.
  • MOD will return a #DIV/0! error if the divisor

0 votes. 0 / 5

Excel - Excel Functions - Excel Formulas
Logo