Spread 8.0 Documentation
MOD
Support Options
Formula Reference > Built-In Functions > MOD

Glossary Item Box

MOD


Name

Mod

Description

Returns the remainder after the Number argument (dividend) is divided by the Divisor argument.

Syntax

MOD(Number, Divisor)

Remarks

Arguments are as follows:

Argument Description
Number Number for which you want to find the remainder (dividend)
Divisor Number by which you want to divide the Number argument

The remainder has the same sign as the Divisor argument.

Data Type

Accepts numeric data for both arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

MOD(R1C2,12)
MOD(B3,10)
MOD(C4,B2)
MOD(255,16)=15
MOD(-3,2)=1

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.