+3 votes
2 views
ago in Office by (226k points)
reopened ago
Excel: Calculate the amount

1 Answer

+4 votes
ago by (1.5m points)
 
Best answer

How to calculate amounts with Excel
1. Calculate the amount of a number:
2. Amount of the value in a cell:
3. Amount of the result of an arithmetic operation:
4. Calculate the amount of a cell range:
Quick start Guide:

Would you like to calculate an amount with Excel? We'll show you how..

image image

The Excel spreadsheet program offers you a number of formulas and functions for a wide variety of purposes. The function with which you can calculate amounts or absolute values ​​is somewhat hidden. You can find out how to use them to calculate amounts in this article.

How to calculate amounts with Excel

You can calculate the absolute value of a number in Excel with the "ABS ()" function. The function outputs the unsigned number as the result. We will show you several examples of how to use the ABS function. Follow our step-by-step instructions or take a look at the brief instructions .

1. Calculate the amount of a number:

image
To calculate the magnitude of a single number, for example -156, write: " = ABS ( number ) ".

2. Amount of the value in a cell:

image
If you want to calculate the absolute value of a value that is in a certain table cell - for example in cell A2 - you need the formula: " = ABS ( cell name ) ".

3. Amount of the result of an arithmetic operation:

image
If you want to perform an arithmetic operation first and then calculate the amount of its result, the arithmetic operation comes in brackets: " = ABS ( arithmetic operation ) ". In the example, cells A1 and A4 are first multiplied before the absolute value of the product is output.

4. Calculate the amount of a cell range:

image
Calculating the absolute value of an entire range of cells is a little more complicated. If there are only a few cells, you can add the individual amounts: " = ABS ( cell name1 ) + ABS ( cell name2 ) + ABS ( cell name3 ) + ... ". With larger cell areas, however, this becomes too cumbersome. Then you can write: " = SUM (ABS (first cell name: last cell name )) "

Attention: The latter is a so-called matrix formula. You must complete this with the key combination [Ctrl] + [Shift] and [Enter] ..

Quick start Guide:

  • Calculate the amount of a number: = ABS ( number )
  • Amount of a cell value: = ABS ( cell name )
  • Amount of the result of a calculation: = ABS ( arithmetic operation )
  • Amount of a cell range: = SUM (ABS (first cell name: last cell name ))

...