Returns the remainder of the division of two numbers. The sign of the result is the same as the divisor.
Syntax
MOD（number,divisor）
Number is the dividend.
Divisor is the divisor.
Description
• If Divisor is zero, function MOD returns the error value #Div/0!.
• Function MOD can be represented by the function INT : MOD(n, d) = n - d*INT(n/d)
MOD function is a The remainder function is used to return the remainder of the division of two numbers, that is, the remainder after the division operation of two numerical expressions.
It should be noted that in the MOD function, the sign of the remainder result returned is the same as the divisor.
Let's practice it to help everyone understand this function.
￭ Suppose we want to calculate the remainder of data one divided by data two
Select the (C2) cell, click to insert the cell, find the MOD function, and click OK.
￭ Here we need to enter two values.
The value refers to the dividend, we select (A2) to fill in, and the divisor (B2) is selected to fill in.
Click OK, and the remainder will be found quickly.
￭ We position the cursor to the lower right corner of cell (C2), and when the cursor appears + glyph, pull down to fill the cell, we can get The remainder result for all data.
Because in the MOD function of EXCEL, the sign of the remainder result returned is the same as the divisor, so (C4) The values of (C5) are all negative.
This function is simple and easy to use, have you learned it~
支付宝扫一扫 
评论列表（196条）
测试