How to multiply cells in excel. Multiplication formula in excel

Sometimes you need to multiply an entire column in Excel by a number. It's very easy to do. Look at the example, let's say we have a column with a price in dollars, but we need a price in rubles, for this we can multiply the entire column by a number - the dollar exchange rate.

So, we need to fill in the price data that is indicated in column B. To do this, we will multiply the data in column A by the dollar rate indicated in cell B1

Select cell B4 and type:

A4*B1, after you have typed (or selected) the link to cell B1, we need to fix it so that the link to B1 does not move (when we stretch the formula), that is, it needs to be made absolute. To do this, in the same cell B4, set the heading to B4 and press the F4 key and your formula will look like:

You can simply type this formula from your keyboard, it’s just much more convenient using the F4 key.

Next, you just need to pull the lower right corner of the cell and the formula will automatically change. Cell B5 will have the formula A5*$B$1, cell B6 will have A6*$B$1, and so on. That is, the reference to the price in dollars will move down, and the dollar exchange rate - B1 will remain unchanged, since it is enclosed in special characters.

Excel is an indispensable program for working with digital data. It has a variety of capabilities. In this article we will take a closer look at how to multiply in Excel.

Multiplying numbers in Excel: options

• Multiplying numbers in one cell. To do this, simply multiply the required numbers in the cell using the multiply icon (*). For example, =3*5, the cell will display the value 15.
• Multiplying a range of numbers by a certain number. You may have a question about how to multiply a column in excel. For example, you need to enlarge each cell of a column by 3 times. To do this, you will need to multiply each cell by 3, how can you do this quickly? The answer is simple - copy the cell with the number 3 and perform the following operation: select the required column and call the menu by right-clicking. In this menu, select " Special insert", and in the window that appears, select insert formulas, operation - multiply.
• Multiplying numbers in different cells. In this case, you can use the “PRODUCT” function, or simply use the multiplication sign. When using the multiplication sign, the writing of the formula differs from the first case only in the use of cell names instead of numbers, for example, =C6*D6. When using the function, multipliers must be written using:
  1. comma (if you are multiplying individual cells), example: =PRODUCT(B2,B4,B6,2)
  2. colon (if you are multiplying a range of numbers), example: =PRODUCT(A2:A4)

In this case, you don’t have to write the names of the cells, but simply select the cell using the cursor; in addition, the multiplier can be not only a cell, but also a number.

You learned about how to multiply in excel. Study the program and it will make your calculations easier.

Excel is especially valuable for what it contains great amount functions. One way or another, they all “revolve” around the table, which is the base and contains all the data for working with calculations and constructing various elements.

Of course, representatives of economic professions use Excel according to their profile, according to the specifications of their work. It is not surprising that such users often need to perform certain mathematical operations, for example, multiply or subtract. Such mathematical operations are not difficult to perform, of course, if you know what the algorithm of actions is. As an example, I suggest you familiarize yourself with how to do multiplication in Excel, and by analogy you can easily figure out the rest of the steps and further.

Multiplying a number by a number

The first method that I propose to consider is the simplest: multiplying two or more values ​​in one cell in Excel. It’s worth starting with the fact that each of the formulas begins with the “=” (equals) symbol, including if you use , SUM, etc. Next, enter the numbers that need to be multiplied with each other, and they are not separated in any way, but exclusively symbol "*" (asterisk). Please note that if you enter another character instead of an asterisk, Excel will try to correct the error for you.

Next, you need to set up the formula. The fact is that although the solution is displayed in the cell, the formula remains in the field above the Excel table. That is why you can change it, the result will immediately appear in the cell.

Multiplying different cells

The multiplication formula in Excel is not limited to just number by number, it is much broader. For example, anyone can multiply several different cells with each other.

1. Enter the numerical data in the required cells.
2. Now in the formula field, enter the coordinates of the cells you want to multiply, for example, A1*A4.
3. Click on the cell in which you would like to see the result, and it will immediately appear there.

As you can see, multiplication in excel table different cells is also quite simple.

Multiplying a range by a number

To make a formula for multiplying a range of numbers by a number in Excel, do the following. In any empty cell, enter the number you would like to multiply by. Next, click on it and select “Copy”. Now enter a range of numbers by entering each number in a separate cell. Then select the required cells and click on “Paste Special”, after which a menu will open in which you need to select the “Multiply” action. I would like to note that when performing this action in the field above the Excel sheet, the formula will not be displayed; it simply does not exist, because this function changes the values ​​directly.

There are other types of multiplication, but I introduced you to the most popular among users. I wish you good luck in mastering the material!

Video to help

The MS Excel program is designed to store data and perform calculations on it. One frequently used action is multiplying numbers. It is used to calculate statistics, find results, and in many other cases. In this article we will learn how to multiply in Excel.

The simplest option is to find the product of predetermined numbers. To perform this operation, use the multiplication command, which has the form of an asterisk - “*”. In order for Excel to perform an arithmetic operation, and not just write information into a cell as text, an equal sign - “=” is written before the product of numbers.

The snapshot shows two random numbers 12 and 28. Please note that cell C5 simply contains the text 12*28, which is displayed as such. In cell C4, we placed the “=” sign in front of the operation, and the program calculated the product. In this way, two or more numbers, both integers and fractions, are multiplied.

It is not possible to multiply numbers in the program very often. Much more common are tasks where it is necessary to calculate the product of the contents of cells or multiply the data in a cell by a number. Let's see how to multiply a number by a field value in Excel.

Young man paying for courses in English. The monthly cost of training is 6800 rubles. We want to know how much it will cost him to study for six months. We write down the cost of classes per month in the first cell, and in the adjacent field we get the result of multiplying it by the number 6.

To use a value from a cell in a formula, provide a link to it. In the example, the number is in field A2, so we write it in the operation.

Let us now assume that if you pay for courses in advance for a certain period, the amount is less than if you pay monthly. Let's calculate how much tuition will cost per year if in different ways payment. The cost of the courses per month is 8200 rubles. If you pay for 3 months at once, the cost will be 23,100 rubles, which you will have to pay 4 times a year. Accordingly, if you transfer money for training twice a year, each time the amount will be equal to 42,300 rubles, and the one-time fee for the year in advance is 73,800 rubles.

Let's record this information in a table and calculate the amounts for each type of payment. Now the formula will contain references to two cells, one of which indicates the payment amount for the period, and the other - the number of such periods in the year. In order not to write a formula for each of the lines, format the information as a table, then in the calculation column, when you enter only the first formula, the program will enter the rest automatically.

Using Functions

Another option is how to multiply by Excel numbers or values ​​in cells, - use the PRODUCT function. If you need to multiply a large amount of data or entire ranges of cells, this function is more efficient than the arithmetic operation. Her call is written like this:

PRODUCT(number1;[number2];…),

where multipliers can be either values ​​or ranges of fields.

The PRODUCT(A1:A6) function will multiply all the values ​​in cells A1 - A6, and the result will be the same as if we wrote the formula A1*A2*A3*A4*A5*A6.

It should be remembered that the function only performs actions on numbers. If there are text values ​​or empty cells in the specified range, the formula will ignore them.

Another way, like 2007 and later, is to paste specially the copied cells. The travel company has a 9% markup on hotel prices. To calculate the cost of selling rooms, we will use the specified method.

Let's copy the purchase prices into the adjacent column, where we will calculate the cost with a markup. We will enter the markup percentage itself - 1.09 - into an arbitrary cell. Now copy the cell with the markup percentage, select the range in which you want to get the works, and select the “Paste Special” menu item. It's in the list of Paste commands on the Clipboard toolbar on the Home tab.

In the settings window, select “multiply” and click “OK”.

We hope this article will help you in the future to easily multiply data in MS Excel and thereby make your work more efficient.

Microsoft Excel is a popular program that is actively used by users to carry out various mathematical calculations. In particular, multiplication can be easily performed using this program. This will be discussed in more detail in the article.

Multiplication is one of the most popular arithmetic procedures, which is most often performed by users in Microsoft Excel and other spreadsheet editors. Below we will look at the main methods of multiplication in this program.

How to multiply in Excel?

Option 1: Multiply multiple values ​​in a cell

Let's say you need to multiply two or more numbers in one cell. This procedure will be performed according to the following formula:

To do this, select any empty cell in Excel in which we want to see the result of our calculations, put an equal sign, and then write down the numbers, putting an asterisk between them (aka the multiplication sign). Thus, write down the required number of numbers that need to be multiplied.

To see the result of the calculation, after entering, you just have to click on the Enter key, after which the number will be displayed in the cell.

Option 2: Multiplying different cells

Let's say in Excel you have numbers in different cells that you need to multiply with each other and get the result of the calculation. To do this, put an equal sign in any empty cell in which you want to see the result of the calculation, and then click on the first cell that contains the number. Insert the multiplication sign (*). Click once with the left mouse button on the second cell, then put a multiplication sign and so on.

In addition, you can enter cells manually. That is, we put the equal sign in exactly the same way, and then write the cell that will be multiplied - in our case it is A2 (the letters must be indicated on the English keyboard layout). Next we put the multiplication sign and write the second cell - for us it is A4. And so on.

To see the result of the calculations, we just have to click on the Enter key.

Option 3: Multiply a range of cells

Let's say the numbers you need to multiply are in the same row or column. In this case, it is more rational to use the range function, which operates according to the following formula:

PRODUCT(first cell:last cell)

In our example, all the numbers are in one column, so select any empty cell and start entering the formula. In our case it will look like this:

As soon as we press the Enter key, the cell will display the result of multiplying the three numbers that were specified in our range.

Option 4: Multiply a range of numbers by a number

And the last option for calculations is when you have numbers in a column or row that need to be multiplied by a certain number, for example, in our case it is the number 5.

In our example, we need to multiply the numbers in the range A2:A6 by the number in cell B2.

Select any empty cell, taking into account that the multiplication results for the entire column will go down from it, and then put an equal sign to indicate the beginning of entering the formula. We will need to multiply two numbers in the formula - the first number of the column, as well as the number, in fact, by which all the cells of the column will be multiplied. Take your time to press the Enter key.

We will need to pin a link to a cell with a number that will be multiplied by all the numbers in the column. This can be done by adding a $ sign in the formula on both sides of the letter in the cell. Thus, our formula takes on the following form.

Press Enter. In the cell in which the formula was entered, the result of counting the first cell in the column by number will be displayed. You can complete the calculation of an entire column by dragging the lower right corner of the cell with the result and stretching it to the end of the column.

Once you release, the program will display the calculation results.

If you have any questions related to multiplication in Microsoft Excel, please share them in the comments.