How to calculate a module in Excel

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

What is a module

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

How to calculate the module in Excel?

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

The syntax of the function of the module is very simple - in Excel you just need to specify the formula "= ABS" in the formula line, then in parentheses you specify the argument that can be a number, a reference to a cell, and also some function that returns a numeric value. You can also perform this operation by pressing the "Insert function" button, where you can select the appropriate function, or by searching using the word "module" or "ABS".

Calculating the sum of modules

One of the most common operations in Excel is the amount modulo. It allows you to add the values of cells without taking into account their sign. To perform this action, you do not need to first calculate the module of each number, and then use the sum function.

When performing an operation associated with multiple values, the module in Excel can work simultaneously with the whole set or range of cells. Thus, to calculate the sum modulo, it is sufficient to use the following query construction:

= SUM (ABS (A1: A4))

Here in column A, the first four lines indicate the values for which you want to add modulo.


To consolidate the understanding of the module description in Excel and the principles of its operation, it is worthwhile to consider a couple of simple examples demonstrating the operation of the function.

To calculate the modulus of a given number or mathematical example, for example difference 2 and 5, use the following entry:

= ABS (2-5)

The result of this query is the number "3".

In case you want to calculate the sum of the elements of the matrix whose values are written in the table, with the range A1: C3, the fastest way to find the answer is to design:

= SUM (ABS (A1: C3))

Similar articles





Trending Now






Copyright © 2018 Theme powered by WordPress.