Shulou(Shulou.com)06/01 Report--

This article mainly introduces the relevant knowledge of "what is the function of MOD function". The editor shows you the operation process through an actual case. The operation method is simple, fast and practical. I hope this article "what is the role of MOD function" can help you solve the problem.

Function: returns the remainder of parameter 1 divided by parameter 2.

Syntax: MOD (num,div)

Note: the parameter num represents the divisor, the parameter div represents the divisor, and the parameter can be a combination of cells or other function formulas whose result is a numerical value. The parameter div cannot be 0, otherwise the error value "# DIV/0!" is returned; the sign of the returned value is the same as that of the div parameter, and the MOD function can borrow the function INT to express: MOD (num,div) = num-div*INT (num/div).

Example:

MOD function is often used with ROW function and COLUMN function to distinguish between odd and even rows and columns of a table.

This is the end of the content about "what is the function of MOD function". Thank you for your reading. If you want to know more about the industry, you can follow the industry information channel. The editor will update different knowledge points for you every day.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.