ABS function in Excel Returns the absolute value of a number. In other words: the ABS function removes the minus sign (-) from a negative number, making it a positive number.
Join the channel Telegram of the AnonyViet π Link π |
How to use the ABS function in Excel
1. For example, the ABS function in cell B1 below returns the absolute value of a negative number.
2. The absolute value of 0 is 0.
3. The absolute value of a positive number is also that number.
4. For example, calculate forecast error (difference between actual value and forecast value) for each month.
5. Simply use ABS to calculate the absolute error for each month.
6. If you don’t want to show forecast errors on the worksheet, use SUMPRODUCT and ABS.
7. Use ABS to calculate the absolute value of each difference.
8. Add the IF function to check if the values ββare within the allowed range.
9. Add icons.
10. Change the allowed range.
In addition, you can also view many other excel articles here.