For example, you have a price list and you need to increase prices by a few percent. You can do this through intermediate calculations using formulas in a free column, then copy the result, paste it instead of the original prices using paste special as a value and delete the formulas, but it’s easier and faster to do it in place. So here's how it's done:
1. In any free cell, write the amount by which we will change prices. In the example, I took a price increase of 5%, that is, multiplying existing prices by 1.05
2. Copy the cell with the entered value and select the price list cells with prices 
3. Click the right mouse button and from the appeared context menu select the item " Special insert"
5. Done! Don't forget to delete the originally entered price adjustment amount, otherwise your customers will be unhappy;) 
You can also perform other mathematical operations with a range: divide, sum, subtract.
Among the many arithmetic operations that Microsoft Excel can perform, multiplication is naturally present. But, unfortunately, not all users know how to correctly and fully use this opportunity. Let's figure out how to perform the multiplication procedure in Microsoft program Excel.
Like any other arithmetic operation in Excel program, multiplication is performed using special formulas. Multiplication operations are written using the “*” sign.
Multiplying regular numbers
Microsoft Excel can be used as a calculator and you can simply multiply different numbers in it.
In order to multiply one number by another, enter the equal sign (=) into any cell on the sheet, or into the formula bar. Next, indicate the first factor (number). Then, put the multiply sign (*). Then, write the second factor (number). So the general multiplication pattern would look like this: "=(number)*(number)".
The example shows the multiplication of 564 by 25. The action is written by the following formula: "=564*25".
To view the calculation result, you need to press the key ENTER.
During calculations, you need to remember that the priority of arithmetic operations in Excel is the same as in ordinary mathematics. But the multiplication sign must be added in any case. If, when writing an expression on paper, it is possible to omit the multiplication sign before the brackets, then in Excel, for correct calculation, it is required. For example, the expression 45+12(2+4) in Excel should be written as follows: "=45+12*(2+4)".
Cell by cell multiplication
The procedure for multiplying a cell by a cell comes down to the same principle as the procedure for multiplying a number by a number. First of all, you need to decide in which cell the result will be displayed. We put an equal sign (=) in it. Next, click one by one on the cells whose contents need to be multiplied. After selecting each cell, put a multiplication sign (*).
Multiplying column by column
In order to multiply column by column, you immediately need to multiply the topmost cells of these columns, as shown in the example above. Then, stand on the lower left corner of the filled cell. A fill marker appears. Drag it down with the left mouse button held down. Thus, the multiplication formula is copied to all cells in the column.
After this, the columns will be multiplied.
Similarly, you can multiply three or more columns.
Multiplying a cell by a number
In order to multiply a cell by a number, as in the examples described above, first of all, put an equal sign (=) in the cell in which you intend to display the answer of arithmetic operations. Next, you need to write down the numerical factor, put the multiplication sign (*), and click on the cell that you want to multiply.
To display the result on the screen, click on the button ENTER.
However, you can perform the actions in a different order: immediately after the equal sign, click on the cell that you want to multiply, and then, after the multiplication sign, write down the number. After all, as you know, the product does not change when the factors are rearranged.
In the same way, you can, if necessary, multiply several cells and several numbers at once.
Multiplying a column by a number
In order to multiply a column by a specific number, you need to immediately multiply the cell by this number, as described above. Then, using the fill marker, copy the formula to the lower cells and get the result.
Multiplying a column by a cell
If in a certain cell there is a number by which the column should be multiplied, for example, there is a certain coefficient there, then the above method will not work. This is due to the fact that when copying, the range of both multipliers will shift, and we need one of the multipliers to be constant.
First, we multiply the first cell of the column in the usual way by the cell that contains the coefficient. Next, in the formula we put a dollar sign in front of the coordinates of the column and row of the cell reference with the coefficient. In this way, we turned the relative link into an absolute one, the coordinates of which will not change when copied.
Now all that remains is to copy the formula to other cells using the fill marker in the usual way. As you can see, the finished result appears immediately.
PRODUCT function
Except the usual way multiplication, in Excel it is possible to use a special function for these purposes PRODUCT. You can call it in the same ways as any other function.
The function template for manual input is as follows: "=PRODUCT(number (or cell reference); number (or cell reference);...)". That is, if, for example, we need to multiply 77 by 55, and multiply by 23, then we write the following formula: "=PRODUCT(77,55,23)". To display the result, click on the button ENTER.
When using the first two options for using a function (using the Function Wizard or the "Formulas"), an arguments window will open in which you need to enter arguments in the form of numbers or cell addresses. This can be done by simply clicking on the desired cells. After entering the arguments, click on the button "OK", to perform calculations and display the result on the screen.
As you can see, in Excel there are a large number of options for using such an arithmetic operation as multiplication. The main thing is to know the nuances of applying multiplication formulas in each specific case.
The Microsoft Excel table editor has a very wide range of capabilities for solving problems of varying complexity in various fields of activity. This is why Excel has become so popular among users around the world. One of the basic skills of working with the program is to carry out simple calculations and mathematical operations. In this article, we will look in detail at how to perform addition, subtraction, multiplication and division in Excel. Let's get started! Go!
Mathematical operations are performed without using a calculator
All calculations in Excel are based on the construction of simple formulas with which the program will perform calculations. First you need to create a table with the values. Please note that each table cell has its own address, which is determined by a letter and a number. Each letter corresponds to a column, and each number corresponds to a row.
Let's start with the simplest operations - addition and subtraction. To add numbers, you can use the so-called “AutoSum” function. It is convenient to use in cases where you need to calculate the sum of numbers that are in a row in one row, column, or in the area you have selected. To use this tool, go to the "Formulas" tab. There you will find the “AutoSum” button. Having selected the section of the table with the values that need to be added, click on the “AutoSum” button. After this, a separate cell will appear containing the result of the calculation. This was the first approach.
The second approach is that the calculation formula is entered manually. Let's say you are faced with the task of calculating the sum of numbers scattered across a table. To do this, make active (click on it with the left mouse button) the cell in which you want to place the calculation result. Then put the “=” sign and, in turn, enter the address of each cell whose contents need to be summed, not forgetting to put the “+” sign between them. For example, you should get: “=A1+B7+C2+B3+E5”. After the address of the last cell is entered, press “Enter” on the keyboard and you will receive the sum of all marked numbers. It is not necessary to enter each address manually. Just click on specific cell and its address will immediately be displayed in the formula field, put “+” after it and move on to the next one.
There is another approach - using the Paste Special function. This method is convenient because it allows you to summarize data from several separate tables, provided that all their columns are the same. First, create a pivot table into which you will paste the copied data. Select the numbers from one table and paste them into the summary table, then do the same with the values of the second table, only this time click on the cell right click mouse and select "Paste Special". In the window that opens, in the “Insert” section, check “Values”, and in the “Operation” section, select add. As a result, all data will be summed up.
Subtraction in Excel is performed in the same way as addition. You will need to enter a formula, indicating the required cells, only instead of the “+” sign, “-” is placed between the addresses.
To multiply numbers in Excel, write a formula, marking the required data and putting an “*” between them. The formula will look like this: “=A3*A7*B2”.
Division is done in the same way, only the “/” sign is used. You can also do multiple arithmetic operations straightaway. Formulas are built according to mathematical rules. For example: "=(B2-B4)*E8/(A1+D1)*D4". The formula you construct can be of any complexity; the main thing is not to forget the basic mathematical rules so that the calculation is performed correctly.
Having mastered the skills of simple arithmetic calculations in Microsoft Excel, you can already simplify the process of solving some problems and save time. Excel allows you to solve complex equations, perform engineering and statistical analysis. Gradually mastering the basic functions and tools of the program, you will learn to perform more and more operations in the Excel editor. Write in the comments whether the article helped you deal with your questions and share your experience with other users.
Those people who often work at a computer will sooner or later come across a program such as Excel. But the conversation in the article will not be about all the pros and cons of the program, but about its individual component “Formula”. Of course, in schools and universities, during computer science classes, pupils and students take a course on this topic, but for those who have forgotten, here is our article.
The conversation will be about how column to column. Will be outlined detailed instructions how to do this, with a step-by-step analysis of each point, so that everyone, even a novice student, can understand this issue.
Multiply column by column
We will look at how to multiply column by column in Excel using an example. Let's imagine that in Excel workbook You have created a table with the cost and quantity of goods. You also have a cell at the bottom with the total amount. As you might guess, you need to quickly multiply the first two columns and find out their sum.
So, here are the step-by-step instructions:
- Select the desired cell and click on the function icon, which is located at the top of the main toolbar.
- A window will appear in front of you in which you will need to select “Other functions”.
- Next, you need to select mathematical functions from the group.
- Select "SUMPRODUCT".
After this, a window will appear in which you will be asked to select a range with the required data; here you can go in two ways. The first implies that you will select the first column (cost) using the cursor and its range will be indicated in “Array 1”, and the second (price) will be indicated in “Array 2”. As you can see, the range was specified in characters (C2:C6). The second method implies that you enter these values manually, this makes no difference.
Now you know one way to multiply column by column in Excel, but it is not the only one, and we will talk about the second later in the text.
Second way of multiplication
To multiply columns in the second way, you will also need to select the "math" function group, but now you need to use "PRODUCT". Now you have two fields in front of you: “Number 1” and “Number 2”. Click on “Number 1” and select the first value from the first column, repeat the same steps with “Number 2”, only select the first value of the second column.
After clicking “OK”, the product of the selected values will appear in the cell with the formula; all that remains is to autofill the cells; to do this, move the cursor to the lower right edge of the cell and drag it down the required number of points.
Now you have learned the second way to multiply column by column in Excel. Now let's talk about how to multiply a number by a column.
Multiply a column by a number
So how do you multiply a column in Excel by a number? In fact, it's even simpler. For this:
- Select the cell where the result will be located.
- Enter the equal sign into it.
- Use the cursor to select the first value from the column, and then select the number by which this value will be multiplied.
- After that, move the cursor over this number and press the F4 key.
- Now all that remains is to hover the cursor over the lower right corner of the cell with the answer and drag it to the required number of points.
Multiplication in Excel is performed in the same way as any other operation, mainly through a formula. But besides formulas, there are other options, and how to multiply in Excel different ways we will look at it in this article.
How to multiply numbers in Excel?
To multiply numbers in Excel, after entering the equal sign in the cell, you need to list the values to be multiplied, between which you need to set the asterisk symbol «*» . It must be remembered that the priority of performing operations is the same as in mathematics and to correctly perform operations with numbers, it is better to use parentheses.
How to multiply cell by cell in Excel?
Multiplying cell by cell in Excel is done by placing an asterisk between the cells being multiplied. «*» .
How to multiply column by column in Excel?
To multiply column by column in Excel, you need to write down the correct formula and stretch it over the entire range of multiplied values. To do this, enter a formula for multiplying the first two values in a column, and apply the formula to all cells along the entire height of the multiplied values.
How to multiply a column in Excel by a number?
To multiply a column in Excel by a number, you can create a formula, indicating the multiplication coefficient in it, or you can, without any formulas, use the menu to multiply the entire selected range of values by any number.
If the number by which the cells will be multiplied is in a table cell, then the reference to this cell in the formula will need to be made absolute so that it does not change when the formula is applied to other cells.
Also in Excel it is possible to multiply a range of values by a number using a special paste with the replacement of the original values. To do this, we need to copy our number coefficient to the clipboard, select the range of cells for multiplication, and on the tab "Home" on the menu "Insert" choose "Special insert...". Or select the same item in the menu after right-clicking on the selected range.
In the window that appears in the column "Operation" choose "Multiply".
Loading...
