[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
MOD ( x , y )
Description: Computes the remainder when x is divided by y. The result has the same sign as y.
Arguments:
|
Name |
Type |
Description |
|
number |
The number for which the remainder is being sought. | |
|
y |
number |
The number by which x is to be divided. |
Return Type and Value: number – The remainder when x is divided by y. The result has the same sign as y. If y is 0, the return value is unspecified.
[Example:
MOD(3,2) results in 1
MOD(-3,2) results in 1
MOD(3,-2) results in -1
MOD(-3,-2) results in -1
end example]