反馈已提交

网络繁忙

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

    FormulaResultNotes
    MOD(3,2)1
    MOD(-3,2)1
    MOD(3,-2)-1
    MOD(-3,-2)-1

    Direct Connect Version

    Overview

    GrammarMOD(number, divisor)

    Returns the remainder after the number is divided by the divisor. The result has the same sign as the dividend.

    Parameter 1numberNumber to be divided (dividend).
    Parameter 2divisorNumber 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

    FormulaResultNotes
    MOD(3,2)1
    MOD(-3,2)-1
    MOD(3,-2)1
    MOD(-3,-2)-1


    Attachment List


    Theme： Advanced Data Analyis
    前の記事
    次の記事
    • いいね
    • 良くない
    • 閲覧しただけ
    中文（简体） 中文（繁體） English
    日本語

    フィードバック

    鼠标选中内容，快速反馈问题

    鼠标选中存在疑惑的内容，即可快速反馈问题，我们将会跟进处理。

    不再提示

    10s后关闭