Function Module in Excel

The module is an absolute positive value of any number. Even at a negative number, the module will always be positive. Let's find out how to calculate the magnitude of the module in Microsoft Excel.

ABS feature

To calculate the magnitude of the module in Excel, there is a special feature called "ABS". The syntax of this function is very simple: ABS (number). Either the formula can take this type: ABS (address_children_s_ch). To calculate, for example, a module from number -8, you need to drive into the string formula or to any cell on the list the following formula: "= ABS (-8)".

To perform the calculation, press on ENTER - the program issues a positive value in response.

There is another way to calculate the module. It is suitable for those users who are not accustomed to keep various formulas in the head.

1. Click on the cell in which we want to keep the result. Click on the "Insert function" button, placed on the left of the formula string.



2. The "Wizard Functions" window starts. In the list, which is located in it, find the ABS feature and select it. I confirm at OK.



3. The function arguments opens. ABS has only one argument - a number, so we introduce it. If you want to take a number from the data that is stored in any cell of the document, press the button placed on the right of the input form.



4. The window will come, and you need to click on the cell, where one contains the number from which you want to calculate the module. After adding it again, click on the button to the right of the input field.



5. Apess the window with the arguments of the function, where the "number" field will already be filled with the value. Click OK.



6. Following this, the value of the module of the number you selected is displayed in the cell that you have selected.



7. If the value is located in the table, the module formula can be copied to other cells. To do this, you need to bring the cursor the lower left corner of the cell, in which there is already a formula, clamp the mouse button and spend it down to the end of the table. Thus, in the cells of this column there will be a value of the module of the source data.

It is important to note that some users try to record the module, as is customary in mathematics, that is | (number) | , for example | -48 | . But in such a situation, only an error will appear instead of response, since Excel does not understand such a syntax.

In the calculation of the module from the number via Microsoft Excel, there is nothing complicated, since this action is performed using a simple function. The only condition is that this feature you just need to know.