Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Absolute Difference Value of Multiple data cells

0

I have multiple data cells that I wish to find the Absolute value of all.

0.0094 0.0074 0.01 0.0084 0.013 0.02

Is this the correct formula ? =ABS(ABS(D3-D4-D5-D6-D7-D8))

Answer
Discuss

Answers

0

To get the absolute value of a number, the value of it without its sign, just use this:

=ABS(D3)

and then copy that formula down the column.

If you want to get the absolute value after you subtract all of those values then one ABS() is all that is necessary:

=ABS(D3-D4-D5-D6-D7-D8)

Discuss

Discussion

Thank you. However, I meant to say, I need the absolute difference of all those values. So is the second equation the correct one to use?
Corrine Aug 4, '16 at 1:42 pm
I'm not sure what you mean by the absolute difference.
don (rep: 1989) Aug 4, '16 at 2:04 pm
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login