This function returns the remainder of a division operation.

Syntax

MOD(dividend,divisor)

Arguments

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 |

Remarks

The remainder has the same sign as the divisor.

Data Types

Accepts numeric data for both arguments. Returns numeric data.

Examples

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