How to multiply the cells in the Excel?

Today, one of the most popular tools for complex computing is the Microsoft Excel program. Its wide functionality makes it possible to simplify the solution of a multitude of tasks, which previously had to spend a lot of time. Today we will look at how to multiply the cells in Exel in large quantities.

Multiplication in "Excel"

Before you figure out how to multiply numbers in Excel, it's worth noting the wide functionality of the program, which allows you to work with both explicit assignment of numbers and using cells that contain both the numbers themselves and the formulas that determine them. In order to multiply one or more cells by a number or other cells, you need to specify the data elements of the sheet in the formula line after the equal sign or write the value yourself.

Multiply cell by cell

Further it is necessary to understand a principle, as in "Excel" to multiply a cell on a cell and with what problems it is possible to meet in the course. To multiply the values of two cells, you need to write the following construction in the formula line: "= A * B", where "A" and "B" are the links to the corresponding elements of the "Excel" sheet, that is, the cells.

Having received the result, you may need to create a copy of it, and often the users, without hesitation, simply copy the value of this cell, inserting it into another. However, with this approach, there will be a change in the corresponding references pointing to multipliers. To avoid such an error, either in the cell where you want to copy the result, enter a reference to the copied cell, or "fix" the address of its multipliers with the sign "$". The dollar sign stores the value of the link by the parameter following it - that is, the reference $ A4 will always refer to the A column, A $ 4 to the fourth row, and $ A $ 4 to the A4 cell only. In other words, fixing a cell is creating an absolute reference to it.

Multiplication of columns and rows

Using the algorithm of fixing the address of the cell, you can go directly to how to multiply in "Excel" column by column or row per line. In order not to waste time writing a huge formula, you can simply use the property of changing the cell reference when transferring to the new address of the pointer. That is, if it is necessary to multiply pairs of values in two columns, it suffices to write the multiplication formula for the first pair of cells, then, holding the "black plus" sign appearing in the lower right corner, stretch the result down along all values of the multiplier columns.

In order to achieve a similar result for the rows, it is only necessary to stretch the result along the corresponding rows. It is worth noting: in order to avoid a shift in the further copying of the results, you need to fix the specified column or string in the formula - then you will be able to avoid errors in the calculation.

Multiplication of a row or column by a cell

Having understood how to multiply in "Excel" a column by a column or a line per line, it is worthwhile to dwell on one specific operation - multiplying a cell by a row or column. If we use the same algorithm of actions in multiplication, as in the case of multiplying columns, the result will only be multiplied by the value of the first row of this column, since the cell address will change with each cell descent by one position.

To avoid this, it is necessary to fix either the row number of the multiplied cell, or its entirety - in this case it will be possible to use its value for several columns. In the case of multiplying a row by a certain cell, it is sufficient to fix the letter of the column in which it is located, or to make both parameters of the cell address constant.

How to multiply all numbers in a row or column

Sometimes in "Excel" you need to perform an operation similar to the total amount, only after performing the multiplication operation. However, there is no special automatic procedure for this, so many people, not knowing how to multiply the numbers of one column or rows in Excel with each other, do it explicitly, recording the action for each cell. In fact, there is an operation in the program that can help solve the question of how to multiply numbers in Excel by several times faster.

In order to multiply a certain range of cells with each other, it is enough to select the operation "PROIZED" in the menu "Insert function". As arguments of this function, you need to specify the cells that must be multiplied by each other, this can be either columns, rows, cells, or whole arrays. It is worth noting that in the presence of an empty cell in a given range, the multiplication result will not be zero - in this case the program will ignore this cell, that is, equate the blank value to unity.

Summary

Having figured out how to multiply in Excel, you can implement fairly complex documents, including economic reports and estimates. Most arithmetic operations can be performed in a similar way, but for some, it is worth considering the specifics of their execution, as well as the format of the cells. So, for example, when dividing a cell into a cell, if there is no value in one of them, the result is a division error by zero.