Math and Trignometric - ABS Function
Advertisements
Description
The ABS function returns the remainder after number is divided by divisor. The result has the same sign as divisor.
Syntax
MOD (number, divisor)
Arguments
Argument | Description | Required/Optional |
---|---|---|
Number | The number for which you want to find the remainder. | Required |
Divisor | The number by which you want to divide number. | Required |
Notes
If divisor is 0, MOD returns the #DIV/0! error value.
The MOD function can be expressed in terms of the INT function −
MOD (n, d) = n - d * INT (n/d)
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016
Example
advanced_excel_math_trigonometric_functions.htm
Advertisements