arctic-methane-emergency-group.org -Mod Formula Description. The Microsoft Excel MOD function returns the remainder after a number is divided by a divisor. The MOD function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the MOD function can be entered as part of a formula in a cell
Mod Formula upport. This article describes the formula syntax and usage of the MOD function in Microsoft Excel. Returns the remainder after number is divided by divisor. The result has the same sign as divisor.
How to use the excel mod function. The Excel MOD function returns the remainder of two numbers after division. For example, MOD(10,3) = 1. The result of MOD carries the same sign as the divisor.
Modulo operation. Modulo operation. Given two positive numbers, a (the dividend) and n (the divisor ), a modulo n (abbreviated as a mod n) is the remainder of the Euclidean division of a by n. For example, the expression "5 mod 2" would evaluate to 1 because 5 divided by 2 leaves a quotient of 2 and a remainder of 1,