MOD(X, Y), MODULUS(X, Y)

 

Description

This function returns the remainder of X/Y with the same sign as X.

 

Parameters

 

X

A numeric value.

 

Y

A numeric value.

 

Examples

 

MOD(8, 4) = 0

 

MOD(D2, F3) = 12

Where D2 = 100 and F3 = 44.

 

MOD(F5, A1) = #Error

Divide by zero (F5 = 98.6 and A1 = 0).

 

MOD(-14, 3) = -2