ABS function

CALC FUNCTIONS

Mathematical Functions

< Previous Section

Next Section >

FUNCTIONS

Trigonometric

• COS
• SIN
• TAN
• COT
• ACOS
• ACOT
• ASIN
• ATAN
• ATAN2
• DEGREES
• RADIANS
• PI

Hyperbolic

• COSH
• SINH
• TANH
• COTH
• ACOSH
• ACOTH
• ASINH
• ATANH

Rounding and remainders

• TRUNC
• ROUND
• ROUNDDOWN
• ROUNDUP
• CEILING
• FLOOR
• EVEN
• ODD
• MROUND
• INT
• QUOTIENT
• MOD

Logarithm/Powers

• EXP
• POWER
• LOG
• LN
• LOG10

Bessel functions

• BESSELI
• BESSELJ
• BESSELK
• BESSELY

Miscellaneous

• ABS
• COMBIN
• COMBINA
• CONVERT
• CONVERT ADD
• COUNTBLANK
• COUNTIF
• DELTA
• ERF
• ERFC
• FACT
• FACTDOUBLE
• GCD
• GCD ADD
• GESTEP
• ISEVEN
• ISODD
• LCM
• LCM ADD
• MULTINOMIAL
• PRODUCT
• RAND
• RANDBETWEEN
• SERIESSUM
• SIGN
• SQRT
• SQRTPI
• SUBTOTAL
• SUM
• SUMIF
• SUMSQ

< Previous Page

Next Page >

ABS

Returns the absolute value of a number.

Syntax:

ABS(number)

number is the number whose absolute value is to be calculated. The absolute value of a number is its value without the +/- sign.

Example:

ABS(-56)

returns 56.

ABS(12.3)

returns 12.3.

ABS(0)

returns 0.

---

See Also

• SIGN

• Mathematical functions

• Functions listed alphabetically
• Functions listed by category