In this space, we will learn to how to return absolute value of particular number or value with signs or symbols like -1,-2,-3, or in our sheet we have some value of losses incurred in particular quarters of that year.

**Previously In Excel Formulas: ****How to get the length of text with LEN Formula?**

Here we have a sheet which has losses incurred in 4 quarters of the year;

Now, we will calculate the absolute value of those loses in a single click by using ABS Formula which is described below;

## STEP1: Working With ABS Formula

In ABS Value section in worksheet we will start working with ABS Function by putting

**=ABS(**

=ABS(number = It implies the cell value of whom you want to get absolute value)

In our Sheet its A2, Therefore,

**=ABS(A2)**

Now we will get the absolute value of -2948391 which is 2948391.

Therefore, by dragging that cell to C5, we will get the result of all losses value as follow;

It’s so easy, isn’t it? 😊