excel function mod usage

The mod function is a remainder function, its format is: MOD(number,divisor) (Number is the dividend. Divisor is the divisor. In Oracle, if divisor is 0, then the function Directly returns number.) is the remainder after division between two numerical expressions. Special note: In EXCEL, the MOD function is used to return the remainder of the division of two numbers. The sign of the returned result is the same as the sign of the divisor.

The usage method is as follows:

Example:

To find the remainder of 5 divided by 3, we can use the MOD function to get it. Input: = MOD (5,3), press the Enter key to get the remainder "2

For more Excel-related technical articles, please visit Excel basic tutorial column!

The above is the detailed content of excel function mod usage. For more information, please follow other related articles on the PHP Chinese website!