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.02Is this the correct formula ? =ABS(ABS(D3-D4-D5-D6-D7-D8))
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.02Is 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:
=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)