MOD function

The Klipfolio MOD function returns the remainder of each value after dividing each value by the modulus value.

The syntax for the MOD function is:

MOD( values , modulus )


values The numeric value whose remainder you want to find. number vector
modulus The number you want to divide by. number scalar

MOD example

Let's look at a MOD function example.




1 Apples 5
2 Oranges 25
3 Pears  
5 Bananas 10

The following example is based on the above text from an Excel spreadsheet:

MOD ( B:B , 2 )

-> [1, 1, 0, 0]

Related links: