MOD

Returns the remainder of a division operation

Updated over a week ago

Description

The MOD() function calculates the remainder when one number (the dividend) is divided by another (the divisor). It's handy for cyclic operations or scenarios where you need to analyze remainders.

Syntax

MOD(dividend, diviser)

Output

number

Variables

  1. dividend: The number to be divided.

  2. divisor: The number by which the dividend is divided.

Example

MOD(`Quantity Sold - NY`,100)

Product

Price (USD)

Quantity Sold - NY

MOD

Product A

25.99

150

50

Product B

14.75

280

80

Product C

7.99

500

0

Product D

35.20

90

90

Product E

50.00

120

20

Did this answer your question?