Absolute Difference Value of Multiple data cells


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))




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


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:




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: 1237) 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