Saltar al contenido

How to get the absolute value of a number in Excel

How to get the absolute value of a number in Excel

Get the absolute value of a number in Excel It is one of the features that this comprehensive program allows you to calculate, among many others. The absolute value of a number is its value regardless of its sign. In Excel it is known as ABS and thanks to it we can get the absolute value of a number in a cell. To know how to get the absolute number in Excel, you need to follow the instructions below.

What is the absolute number for Excel?

What is it absolute number or absolute value (ABS) of a figure? This is a concept that is used in Excel so that the reference of a cell in a formula is constant when it is copied. Thus, the value of the cell will be invariable even if we pull it out.

Differences between relative value and absolute value

When working with Excel, we need to consider two types of values:

  • Relative values: are those that we place in formulas and that, when copied to other cells, change automatically
  • Absolute values: are placed in specific cells and, when copied to other cells, remain unchanged. No matter where we shoot them, their value will not change under any circumstances

How do you indicate the absolute range in Excel?

Indicating the absolute value of a figure in a cell is very simple. All we have to do is put the $ sign before the Excel column and before the row we want to keep unchanged.

Example of absolute value:

This function tells us that cell C1 will not change the digit, even if we change it.

absolute references can be combined with relative references to obtain very specific data. Knowing the features and all the functions that we can perform with Excel is interesting to perform more work. For example we can make the representation of a bar graph among other tasks.

Did you know …

At first, Excel was created for Mac, and later ported to Windows.

Was it useful to you? Loading …