ABS()
Syntax. ABS(number)
Definition. This function returns the absolute value of a number. The absolute value of a number is the number without its sign.
Argument
number (required) The real number for which you want the absolute value
Background. Consider the following scenario: The integers 3 and –3 are located respectively on the right and left sides of 0 on a number line. However, both integers have the same distance to 0. Thus, both numbers have the same absolute value (see Figure 16-1).
Figure 16-1. Both integers are the same distance from 0.
Absolute values are enclosed in two vertical bars:
|a| = |-a|
Example. Absolute values are used in numerous ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out 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.