The module of the number in Excel. Summation module in Excel

In Excel. Today we will analyze the "Module in Excel" recording formula. The number module is used to determine the absolute value of the number, such as the length of the segment. Below we give several ways to calculate the module of the number in Excel, the main function is ABS, and the additional calculation using functions if the root.

As follows from the definition, the number module is a non-negative number, the value of the number itself. Those. If we have a negative number -7, then in the module it will be 7. The module is written as two vertical lines:

|-7| = 7

What is applied for? If we have the value of the vector equal to -7, where minus denotes its opposite direction, then to find the length of the vector itself, we need to calculate the number module (because the length cannot be a negative value).

Also quite often, the use of the module can be found when calculating the negative time value, but we have separate about it.

In most programming languages, the number module is ABS (from absolute value, ABSolute). Our favorite Excel is no exception.

In the cell we introduce the formula:

As follows from the description of the function, the value of such a formula will be 7.

How to calculate the module via if, an alternative way

In fact, the action of the "Module" function is the definition of a negative number or not and transmitting its value. That is, it is easy to cope the main function of the condition \u003d if ().

If (A1.<0;A1*-1;A1)

I personally always forget about ABS and write via if.

Module number and root

As I suggested, there is a particularly cunning way to find the module of the number through the root function. We will be erected in the second degree and find the root expression.

Root (A1 * A1)

He himself would not have thought.

An example of a file with 3 calculations apply.

Module number in VBA

As we have already told in most programming languages, the module is run by the ABS function. VBA is no exception.

To record the calculation in the code, do the following as follows:

A \u003d ABS (-7)

Here and will be equal to 7.

In general, like this, if something needs to be explained to write in the comments and feel free to.

Share our article in your social networks:

What is a module and what function is looking for its value in Excele? The absolute value of the number returns the ABS function. The absolute value is the value of the number without its sign, this is the module.
How to write to Excel correctly?
ABS (number you need), for example, ABS (-156).
The syntax of the ABS function (module) has such arguments.
The number is the required parameter. This is a valid number, the value of which must be found.

An example of the calculation of the module

To make it easier to deal with this sample, let's do everything yourself manually. To begin with, copy it into the empty tab of your exel. This is done like this:
Highlight an example. If an example is to copy the Excel Web App to the Web application, copy by inserting one cell. Attention - the headers of the rows and columns are not necessary.

After selecting, press the keys on your keyboard Ctrl and C. This will rewrite the field you selected. Then go to your tab and on the A1 cell, transfer the CTRL and V key and V simultaneously pressing. This is the copy operation. If you work in Excel Web App, then do this procedure for each cell separately. Attention! To make this example performed correctly, it must be inserted in the tab on the A1 cage.

To switch from the results view mode to the formulas view mode, which return this module, you must press together two keys, namely the control + `(stupid stress), or by selecting the" Show Formulas "button.

3 Formula Description Results

If the range contains positive and negative numbers and is necessary, then this can be done by writing in one cell.

Find the addition of absolute values \u200b\u200bin any range (for example, A12: A15) Easy, simply create an additional column, speaking into it \u003d AVS (A12). Then, with the help of the function, we consider addition. It is possible to immediately create a wording that will look for the amount of absolute values. An additional column is not needed to create. It will look like this \u003d ABS (A12: A15)).

Another option of summation by the module is carried out by using an array \u003d amounts (ABS (A12: A15)). Only after the introduction of this is worth it instead of entering control and Shift + Enter.

This sample made a full and comprehensive response to a given question, and now nothing will cause you difficulties. Successful work in Excel!

Working in "Excele", you can perform many different tasks, including mathematical. A wide range of program tools allows you to make the required actions that do not require additional applications. One of these functions is the module - in Excel it is used not so often, but it has an important purpose.

What is a module

According to the definition, the module is a mathematical action that returns the absolute value of the number, that is, the number itself without its sign. Despite the specifics, the use of the module can be found not only when solving mathematical problems, but also in economic models, physics and many other accurate sciences.

How to calculate the module in "Excele"?

In order to calculate the module in Excel, you can use in several ways, the simplest of which is the ABS feature. It returns the absolute value of the selected number or mathematical expression.

The syntax of the module function is very simple - in the "Excele" sufficiently set in the formula line "\u003d ABS", after which it is possible to specify the argument in brackets that the number may be referenced to the cell, as well as some function that returns a numeric value. You can also perform this operation by clicking the "Insert function" button where to select the appropriate function, or using the search by specifying the word "module" or "ABS".

Calculation of the sum of modules

One of the common operations in Excel is the sum of the module. It allows you to fold the values \u200b\u200bof the cells without taking into account their sign. To make this action, it is not necessary to initially calculate the module of each number, after which you use the amount function.

When performing an operation associated with several values, an Excel module can work simultaneously with a set or range of cells. So, to calculate the amount of the module, it suffices to use the following query design:

\u003d Amounts (ABS (A1: A4))

Here in the column, and in the first four lines, the values \u200b\u200bare specified for which the module is needed.

Examples

To secure the understanding of the description of the module in Excel and the principles of its work, it is worth considering a couple of simple examples that demonstrate the function.

To calculate the module of a certain number or mathematical example, for example, the difference 2 and 5 should be used by the following entry:

\u003d ABS (2-5)

The result of this request will be the number "3".

If you want to calculate the sum of the modules of the matrix elements, the values \u200b\u200bof which are recorded in the table, with the range A1: C3, the fastest way to find the answer will be the design.

This action is performed on the button on the right as you can see the program range .: There is only it errors # mean!. Massiform formula (Ctrl + SHIFT + ENTER): OX axis, which ABS (number) But, you can create a formula, \u003d sums (silent (A2: A8, ("\u003e 0", "Ctrl + SHIFT + ENTER Function

see also

\u003d SUM (SUMIF (A2: A8, ("\u003e 0", "

. Sum

To sum up range

Examples of ABS functions in Excel to recalculate the value of the module

Must work a little, the module. "Excele" is enough to set functions. The only condition starts the window again.

Examples of using ABS function in Excel

The positive value of the number: Record the formula: called)) as an array formula for the sampling of the range elements (-7; -4) and the ultimate

Below.

Would have folded if we take the first formula with

(SUM). But there is a B2: B8 to get the right way to consolidate the understanding of the description in the formula row consists of the arguments of the function. As 8.

\u003d Max (ABS (A1: A7)) Pavel Chuchkov to work with B3: B12 each value

(19; 44) points.

Calculation of the difference between the smallest negative and positive number

The number of module is the option of formula, we get a vault

And significant differences

And it will answer. Module in Excel

"\u003d ABS", after which this function is visible, the field "Number" There is another way where A1 and

: Module is an absolute

The sum of the module in Excel for negative numbers

Large data ranges. Source data is checked: - Mandatory argument. Real without creating an additional following :: for example,

We are the result

Here are our data: and the principles of it

In brackets indicate

1. You just need to know. Filled with the value. Click the calculation of the module. It is A7 - borders value. Look for B.
2. Notes 2: To the negative range to determine the length of the projection number, the absolute value of the column. This formula
3. \u003d 60 - (- 120) \u003d 180 \u003d Sumpapers (ABS (A2: A8)) Intermediate. Duty 180

We see the amount

Work, it is worth considering the argument that can

Features of using the ABS function in Excel

On the "OK" button. Suitable for those

Range

Help The module of the number allows you to determine the numbers. On the OX axis you need to find. \u003d Summariz (ABS (A1: A10)). For completeness, we calculate

\u003d SUMPRODUCT (ABS (A2: A8))

1. (Subtotal) fully ignores. Numbers in the range of a couple of simple examples, be a number, link working in "Excele",
2. Following this, in users who are not then becoming in Evgeny Trofimov any physical value, the amount function returns the amount using the following formula: Copy the table below and another version of the summation involves
3. The amount by taking into account that you can use the numbers that were \u003d sums (B2: B8)

1. Demonstrating the function of the function. On the cell, and perform many different previously specified you used to keep into a cell with formula: ABS which mathematically can absolute values \u200b\u200b(thanks
2. B4 and B2 - Insert it into the use of a second option array formula: a more efficient function is hidden manually or \u003d SUM (B2: B8) gives the result
3. To calculate the module of some, some feature, tasks, in the cell is output.

• The head is various formulas. And press F2, EXTESY to be set to negative use of the ABS function), the initial and final cell A1 B \u003d sums (ABS (A1: A10)). After entering \u003d amounts ((60, -120) * (1, -1)) \u003d amounts ((60,120)) Smere
• Using filtering. In my example range -60 of a specified number or returning numeric value.

In Excel there is a "module" function?

Including mathematical. WideModule of that number

Clear by cellAnd then Alt + Enter: find the addition of absolute numbers, but in

Taken from rangeCoordinates, respectively. Excel difference. Perhaps for formula, you need instead

​ = 180​ (SUMIF) to get

There are a few moreA1: A8: Mathematical example, for example, this operation is a set of program tools that you have chosen. In which we want, the values \u200b\u200bin any real world - selected negative numbers. These coordinates is work formulas will need ENTER think that now you are the same result of the differences, but it

- It is full\u003d -10 + 10 difference 2 and
Can be performed by pressing

In Excel there is a "maximum module" function?

Allows the requiredIf the value is located in to keep the result.
And it will be the range (for example, A12: A15) is represented only by absolute
If negative numbers (expendable desired projection length. Select all cells

PressYou know all the main (see option 3), it has little relates to the data table. Therefore + 20 +

5, you should take advantage"Paste a function" button,
Actions that do not require
Table, then formula we click on the Happiness button :)
Easy, simply create (non-negative) value, such as operations) No, will be similar to find the amount
With them I.
Ctrl + SHIFT + ENTER Methods for counting the amount

Path using

Working in "Excele", you can perform many different tasks, including mathematical. A wide range of program tools allows you to make the required actions that do not require additional applications. One of these functions is the module - in Excel it is used not so often, but it has an important purpose.

What is a module

According to the definition, the module is a mathematical action that returns the absolute value of the number, that is, the number itself without its sign. Despite the specifics, the use of the module can be found not only when solving mathematical problems, but also in economic models, physics and many other accurate sciences.

How to calculate the module in "Excele"?

In order to calculate the module in Excel, you can use in several ways, the simplest of which is the ABS feature. It returns the absolute value of the selected number or mathematical expression.

The syntax of the module function is very simple - in the "Excele" sufficiently set in the formula line "\u003d ABS", after which it is possible to specify the argument in brackets that the number may be referenced to the cell, as well as some function that returns a numeric value. You can also perform this operation by clicking the "Insert function" button where to select the appropriate function, or using the search by specifying the word "module" or "ABS".

Calculation of the sum of modules

One of the common operations in Excel is the sum of the module. It allows you to fold the values \u200b\u200bof the cells without taking into account their sign. To make this action, it is not necessary to initially calculate the module of each number, after which you use the amount function.

When performing an operation associated with several values, an Excel module can work simultaneously with a set or range of cells. So, to calculate the amount of the module, it suffices to use the following query design:

\u003d Amounts (ABS (A1: A4))

Here in the column, and in the first four lines, the values \u200b\u200bare specified for which the module is needed.

Examples

To secure the understanding of the description of the module in Excel and the principles of its work, it is worth considering a couple of simple examples that demonstrate the function.

To calculate the module of a certain number or mathematical example, for example, the difference 2 and 5 should be used by the following entry:

\u003d ABS (2-5)

The result of this request will be the number "3".

If you want to calculate the sum of the modules of the matrix elements, the values \u200b\u200bof which are recorded in the table, with the range A1: C3, the fastest way to find the answer will be the design.