abs

[connect1]

in what circumstances is this used?

[Speshul]

ABS will return the absolute value of a number. It will make negative numbers positive, and positive numbers remain positive.

For example,

ABS(10), will return 10
ABS(-10) will return 10 as well

Please see here for more information

[AlKey]

It is used to return a number without a sign.

Row\Col	A	B
1	Values	=ABS(A2)
2	2	2
3	-3	3
4	-54	54
5	35	35