top menu gradient

Back to website

Reference

MOD

Returns the result of the modulo operator, the remainder after a division operation.

Syntax

=MOD(dividend, divisor)

Parameters

dividend
- Type: Number
- Description: The initial value.
divisor
- Type: Number
- Description: The incrementer.

Returns

Type: Number
Description: The remainder after a division operation.

Example

MOD(10, 4)

Copy to clipboard

See Also

/docs/reference/functions/abs/

/docs/reference/functions/average/

/docs/reference/functions/ceiling/

/docs/reference/functions/count/

/docs/reference/functions/floor/

/docs/reference/functions/max/

/docs/reference/functions/min/

/docs/reference/functions/power/

/docs/reference/functions/randbetween/

/docs/reference/functions/random/

/docs/reference/functions/round/

/docs/reference/functions/series/

/docs/reference/functions/sort/

/docs/reference/functions/sum/

Previous – FunctionsMINUTE Next – FunctionsMONTH

Contents