How to put absolute value in Excel? Within this article we will teach you, with simple steps.
It is well known, that Excel is a ssoftware, capable of organizing, storing and classifying all kinds of data and information. It is extremely complex to use, but very helpful when we want to maintain the entire organization of a business, location, history, among many others.
Excel, as an intelligent tool, also allows us to carry out endless mathematical operations, the same ones that we often need, within our projects, jobs, or records mentioned above.
So ultimately, Excel can help us calculate the absolute value, for this you must also know. That for its part, the absolute value is the distance that exists between a certain number and zero, this means that the result obtained will always be a positive number, even if the value is really negative.
In this way, Excel also allows us to add a whole range or list of positive and negative numbers within its worksheets.
If you want to know, how you can do all that, stay inside this tutorial, where we will teach you how to put absolute value in excel.
Excel functions that allow us to put the absolute value
Actually Excel, has different functions, which allows us to calculate and add the absolute value of a number, within its worksheets, these functions are the following:
ABS function
This is one of the first functions, which are recommended if we want add absolute value in an excel spreadsheet. Within it, the absolute value of a number is established, within a single specific cell. This is a basic function, which can't really add absolute values automatically, but allows us to do it manually.
In order to carry it out, we must do the following:
Open a blank Excel sheet and start entering -3454 in cell B3, then you must select the next cell, B4, being on it press the command “Fx” This will open a new window, where you must select “insert function”. Then a drop-down menu will appear, where you must select the category “ABS”, a new window will instantly open below it.
Then you must click on the “cell reference” button for the field “number” and again select cell B3. Then you will have to click on “OK”, that way the information will be added. ABS function inside spreadsheet. In that you will notice that cell B4 will now take the value of 3454.
If you want, you can also get the absolute value for a range of cells, with this same function, by adding the ABS column inside the spreadsheet. Then you can insert the ABS function to that column, by entering the equation =SUM, in a cell at the bottom of the column, that way you can also add the absolute values obtained.
And that's it. Too easy, right? That way you will have placer the absolute value inside an excel sheet.
Combination of ABS with the SUMPRODUCT function to put the absolute value in Excel
The ABS function, in short, is quite useful for calculating the absolute value and can also be combined with other functions, in this case we are talking about the SUMPRODUCT function, which allows us to give negative or positive ranges to the absolute value.
To put absolute value in excel, using these two functions, you should do the following:
You must first open a new Excel sheet. And then fill it with invented data. You can enter the values 4, 4 and 7 in cells A2, A3 and A4. Then you must select cell A5 and click, inside the bar called "effects". Then you must enter the function =SUMPRODUCT(A2:A4), in the same "effects" bar after you must select "OK" or "Intro”, this will make cell A5, become the number 7, which is not really the absolute value.
Then you must find the true absolute value, for this we need to join the ABS function with the previous steps, so the function with its original equation must be changed to this =SUMPRODUCT(ABS(A2:A4)). That will cause A5 to become 15, that is, 4+4+7, so that the cell range, gives a direct result.
Ready! Although this option may seem somewhat more complicated than the previous one, when you put it into practice, you will notice how simple it is.
The SUMIF function to find the absolute value in Excel
This function allows Excel users to add values that meet a series of specific criteria. With it we can also find the absolute value, for a given range of cells, we just have to add the following equation SUMIF(range, criteria,[sum_range]). That way you can find the absolute value, automatically.
On the other hand, if you want the operation to be carried out in a more manual way, enter the function in the “effects”. Selecting cell A6, then entering the data enter =SUMIF(A2:A4,»>0″)-SUMIF(A2:A4,».
And that would be all, easier impossible.
The Kutools plugin
This one, on the other hand, is an external tool, but it works very well together with Excel, with it you can carry out different operations and among them, that of find the absolute value, it also helps us to change the signs of values, going from negative to positive numbers, within our Excel sheet.
If you want to access all its functions and benefits, all you have to do is install it on your computer and start working with it.
Conclusion
There are actually a few ways to find the absolute value of a range of numbers within an Excel spreadsheet. But each one of those explained above, manages to fulfill that desired function, which is put absolute value inside excel.
On your part, all that remains is to search and identify the one that is easiest for you and, obviously, the one that best suits the needs you have as an Excel user.
For the rest, we only hope that you liked the article and that you already know how to put absolute value in excel.