Excel ABS Function

How to convert Negative numbers in excel to positive..? or How to find the absolute value of any number in excel...?

If you have a data base which contain positive and negative numbers and you want to convert all the negative numbers into positive ,at same time positive numbers should remain as it is.Let see how it is possible in excel.

Summary 

The Excel ABS function returns the absolute value of a number. Negative numbers are converted to positive numbers, and positive numbers are unaffected.

Purpose 

Find the absolute value of a number

Return value 

A positive number.

Syntax 

=ABS (number)

Arguments 

number - The number to get the absolute value of.

Use

To convert Negative numbers in to positive.

To find the Absolute value of a Number.

To find the distance between Zero to any Number.

ABS Function Errors

If you get an error from the Excel Acos function, this is likely to be one of the following:

Common Errors

#NUM! - Occurs if the supplied number argument is outside the range -1 to +1.
#VALUE! - Occurs if the supplied number argument is non-numeric.