Microsoft Office Tutorials and References
In Depth Information
MOD
MOD The MOD function returns the remainder after number is divided by divisor. The result has the
same sign as divisor.
=MOD(number,divisor)
For example: MOD(6,5) equals 1 and MOD(5,5) equals 0. Sometimes it may be desirable to use
the following equivalent formula.
MOD(n,d) = n - d*INT(n/d)
The NUMBER argument is the number for which you want to find
the remainder.
NUMBER
The DIVISOR argument is the number by which you want to
divide your number. If divisor is 0, MOD returns an error value.
DIVISOR
MROUND
The MROUND function returns a number rounded to the desired multiple.
=MROUND(number,multiple)
This function is available from the Analysis ToolPak under Tools, Add-Ins in the menu if the
box for that add-in is checked. If it is not in the add-in list, run Setup to install it. For example:
=MROUND(5000, 75) returns 5025.
The NUMBER argument is the value to round.
NUMBER
The MULTIPLE argument is the multiple to which you want to
round the number.
MULTIPLE
MULTINOMIAL
The MULTINOMIAL function returns the ratio of the factorial of a sum of values to the product
of factorials.
=MULTINOMIAL(number1,number2, ...)
This function is available from the Analysis ToolPak under Tools, Add-Ins in the menu if the
box for that add-in is checked. If it is not in the add-in list, run Setup to install it. For example:
MULTINOMIAL(5,7) equals 792.
The NUMBER arguments are 1 to 29 values. If any value is
not an integer, it is truncated. If any argument is 0, it is
ignored. If any argument is nonnumeric or less than 1,
an error value is returned. You also can use ranges of
values in place of single number values in this function.
NUMBER 1, NUMBER 2, ...
Search JabSto ::




Custom Search