© Mandeep Mehta 2021
M. MehtaMicrosoft Excel Functions Quick Referencehttps://doi.org/10.1007/978-1-4842-6613-7_9

9. Math Functions

Mandeep Mehta1  
(1)
Mumbai, India
 

In this chapter, we will look at some of the math functions provided by Excel.

Note

In the text functions in this chapter, the argument number can be

  • a literal numeric value,

  • an Excel function returning a numeric value,

  • a cell reference where the cell contains a numeric value, or

  • a named range referring to numeric values.

ABS Function

The ABS function returns the absolute value of a number without the sign. Negative numbers passed are converted to positive numbers, whereas positive numbers are unaffected.

Syntax

=ABS(number)
The ABS function takes only one argument, as follows:
  • The number whose ...

Get Microsoft Excel Functions Quick Reference: For High-Quality Data Analysis, Dashboards, and More now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.