[PDF]Abs Function In Excel

Imparting knawledga


%


Cyan Sangrah


abs function in excel


abs function is used to find the absolute value of the number.

What is absolute value of a number?


In mathematics, absolute value of a number is the distance of that number from zero in
number line ( https://en.wikipedia.org/wiki/Number_line "I.

For example the distance between -4 and 4 from zero is 4.


4



.6 -5 -4 -3 -2 -1 0 1 2 3 4 5 6



4


|- 4|=4

So the output of absolute number is a positive number.

Syntax

=ABS (number) or = ABS (excel_cell)


Example