ExcelBanter - absolute value

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - absolute value (https://www.excelbanter.com/excel-worksheet-functions/111225-absolute-value.html)

absolute value

is there a way to calculate an absolute value for a number in a cell? for
example, if you the number in a cell is 2 or -2, the value given in another
cell would be 2.

thanks.

Eric

Toppers

absolute value

=ABS(A1)

"EG" wrote:

is there a way to calculate an absolute value for a number in a cell? for
example, if you the number in a cell is 2 or -2, the value given in another
cell would be 2.

thanks.

Eric

Domenic

absolute value

Try...

=ABS(A2)

Hope this helps!

In article ,
EG wrote:

is there a way to calculate an absolute value for a number in a cell? for
example, if you the number in a cell is 2 or -2, the value given in another
cell would be 2.

thanks.

Eric

Dave F

absolute value

ABS(A1) will give you the absolute value of A1
--
Brevity is the soul of wit.

"EG" wrote:

is there a way to calculate an absolute value for a number in a cell? for
example, if you the number in a cell is 2 or -2, the value given in another
cell would be 2.

thanks.

Eric

All times are GMT +1. The time now is 04:27 PM.