REMAINDER

REMAINDER returns a rounded remainder when one number is divided by another using this equation:

n2 - (n1 * N)

where N is the integer nearest n2/n1.

Return Value

NUMBER

Syntax

REMAINDER(n2, n1)

Arguments

n1 is a numeric expression for the divisor.

n2 is a numeric expression for the dividend.

Example

REMAINDER(18,7) returns the value -3.