In This Topic

MOD

In This Topic

This function returns the remainder of a division operation.

MOD(*dividend*,*divisor*)

This function has these arguments:

Argument | Description |
---|---|

dividend |
Number for which you want to find the remainder by dividing the divisor into it |

divisor |
Number by which you want to divide the dividend argument |

The remainder has the same sign as the divisor.

Accepts numeric data for both arguments. Returns numeric data.

MOD(B3,10)

MOD(C4,B2)

MOD(R1C2,12)

MOD(255,16) gives the result 15

MOD(-3,2) gives the result 1

See Also