absolute value

[EG]

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]

=ABS(A1)

 

[Domenic]

Try...

=ABS(A2)

Hope this helps!

 

[Dave F]

ABS(A1) will give you the absolute value of A1