REM

REM returns the remainder of x divided by y.

This can be calculated by:
  x - y * trunc(x/y)

Read syntax diagramSkip visual syntax diagramREM( x, y)
x and y
Expressions. x and y must be computational and can be arithmetic.

For examples that contrast the REM and MOD built-in functions, refer to MOD.