Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Calculate the Absolute Value with ABS Function in Excel

Date:2019-10-14 Author:Cordelia

Calculating the absolute value is very common in Excel data processing. To fulfil the task quickly and accurately, you don’t need to do the operations by your own. Just make use of ABS function, you can get the absolute values of a batch of data in seconds.

1. Create a new column to output the absolute value.

How to Calculate the Absolute Value with ABS Function in Excel

2. Enter the formula of ABS function in B2: =ABS(A2) and press [Enter] to work it out.

How to Calculate the Absolute Value with ABS Function in Excel

3. Or you can click the fx button above the sheet to Insert Function.

4. Type ABS in the textbox under Search for a function and hit Go.

5. Choose ABS in the list of search result. Click OK to insert it.

How to Calculate the Absolute Value with ABS Function in Excel

6. Then specify the cell to calculate in Function Arguments and hit OK.

7. Now the absolute value of A2 is worked out and displayed in B2. Use fill handle to apply the ABS function to other cells in column B. Then you can get the absolute values of all the original data at once.

How to Calculate the Absolute Value with ABS Function in Excel

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *