Please enable JavaScript

+4 votes

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..

** 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. **

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 .

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

- 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*))