Math and Trignometric - ABS Function

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

ABS Function
advanced_excel_math_trigonometric_functions.htm
Advertisements