This function will give you the absolute value of a number.

**Number** – This is the number that you want the absolute value for. It can be a reference or a number

Column B are the results. Column C is the formula.

__Examples:__

**In cell B2 – **We want to find the absolute value of the number in cell A1. So we used the formula =ABS(A1). So it gives you the absolute value of 33.4 which is 33.4.

**In cell B3 – **We want to find the absolute value of the number in cell A2. So we used the formula =ABS(A2). So it gives you the absolute value of -22 which is 22.

**In cell B4 – **We want to find the absolute value of 11. So we used the formula =ABS(11). So it gives you the absolute value of 11 which is 11.

MasterExcel says

very easy and very useful!