MOD - Returning the Remainder After Division of Two Numbers

Last update： 2023-07-14

Extracted Data Version

Overview

Grammar	MOD(number, divisor)	Returns the remainder after the number is divided by the divisor. The result has the same sign as the divisor.
Parameter 1	number	Number to be divided (dividend).
Parameter 2	divisor	Number that divides another number (divisor). If the divisor equals 0, the remainder is returned as infinite; if the dividend equals 0, the remainder is returned as 0.

Notes

The function supports two numerical parameters.

Example

Formula	Result	Notes
MOD(3,2)	1
MOD(-3,2)	1
MOD(3,-2)	-1
MOD(-3,-2)	-1

Direct Connect Version

Overview

Grammar	MOD(number, divisor)	Returns the remainder after the number is divided by the divisor. The result has the same sign as the dividend.
Parameter 1	number	Number to be divided (dividend).
Parameter 2	divisor	Number that divides another number (divisor). If the divisor equals 0, the remainder is returned as infinite; if the dividend equals 0, the remainder is returned as 0.

Notes

The function supports two numerical parameters.

Example

Formula	Result	Notes
MOD(3,2)	1
MOD(-3,2)	-1
MOD(3,-2)	1
MOD(-3,-2)	-1

Previous

Next

Helpful
Not helpful
Only read

中文（简体）中文（繁體）日本語

English

滑鼠選中內容，快速回饋問題

滑鼠選中存在疑惑的內容，即可快速回饋問題，我們將會跟進處理。

不再提示

10s後關閉

Get
Help

*Problem Type

Incomprehensible Content Incorrect Content Incomplete Procedure Other Content Problems Doc Page Function Feedback

Cannot be empty

Problem Description

0/1000

Cannot be empty

Submitted successfully

Network busy