See also, and don’t confuse with: ABC analysis in Excel
| Function category | Math and trigonometry |
| Volatility | Non-volatile |
What does the ABS function do
The ABS function returns the absolute value of a number. By definition, the absolute value is always a positive number. The absolute value of a negative number equals the number multiplied by -1.
Function syntax
=ABS(number)
Usage examples
Example 1
The table above was created by a call center manager to identify problematic hours in their operation.
The manager’s task is to minimize human resources spent while maintaining maximum speed in answering incoming calls.
The table shows the average customer waiting time on the line. Both sharp increases from hour to hour and sharp decreases in this metric are bad signals.
Column D uses simple subtraction of the previous hour’s value.
The manager uses the ABS function to identify hours when the difference is maximum, in order to adjust employee schedules and “smooth out” the graph.
Conditional formatting helps quickly identify that some employees should be kept for an extra hour at 16:00 on this day, and more employees should be scheduled at the very beginning of the shift.
Example 2.
The same manager uses a similar table but for all days of the week. To avoid cluttering the table with extra calculations, they use the ABS function in an array formula.
How does the calculation work in the formula? First, the absolute value is calculated for each array element using the ABS function, and then these absolute values are summed.
Like all array formulas, this formula is entered without curly braces, but the cell entry is done using Ctrl + Shift + Enter.
The formula calculates the cumulative value of “problematic” hours during each day and allows the manager to identify days with the most unbalanced schedule.
Other Math and trigonometry functions
SIGN, MMULT, ISODD, GCD, LCM, CEILING, FLOOR, ROUND, ROUNDUP, ROUNDDOWN, MROUND, MOD, TRUNC, PI, PRODUCT, ROMAN, RANDBETWEEN, RAND, POWER, SUM, SUMIF, SUMPRODUCT, FACT, INT, QUOTIENT, ISEVEN, COMBIN
Like the article? Help its author! Buy !SEMTools, it has lots of useful instruments to process text data.
This post is also available in RU.