# Excel: Calculate the amount

14 views
in Office
reopened
Excel: Calculate the amount

by (1.6m points)

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.

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

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