Microsoft Excel is a program designed for the Windows operating system. Its main purpose is to create tables and work with them. The spreadsheet editor has a wide functionality and allows you to facilitate operations with a large array of numbers.
![How to make a formula in Excel How to make a formula in Excel](https://i.compthesaurus.com/images/026/image-77772-1-j.webp)
Excel has the ability to create formulas of varying complexity: from the simplest to macros. This will facilitate the work of not only a specialist, but also an ordinary user.
Addition
To add several numbers in a column, you can use the "auto-sum" function (∑ icon). Place the cursor on the area where the amount should be.
![sum sum](https://i.compthesaurus.com/images/026/image-77772-2-j.webp)
Find the ∑ sign, click on it, press "Enter". The amount has been calculated.
![sum sum](https://i.compthesaurus.com/images/026/image-77772-3-j.webp)
To add several values, you can do it differently. We put the equal sign, click with the mouse one by one on the values that we need to add.
![sum sum](https://i.compthesaurus.com/images/026/image-77772-4-j.webp)
We put a plus sign between the values, press Enter.
![sum sum](https://i.compthesaurus.com/images/026/image-77772-5-j.webp)
This is how we added the values of two columns in one table differently.
Subtraction
To create a subtraction formula, proceed in the same way. Place the cursor on the cell where the difference of numbers will be, click "equal". Next, with the mouse, first mark the decrement, then put the "minus", mark the subtracted and click "Enter".
![subtraction subtraction](https://i.compthesaurus.com/images/026/image-77772-6-j.webp)
The resulting value is "stretched" over the entire column. To do this, move the cursor to the lower right corner of the desired area so that a cross appears, press the left mouse button and drag it down.
![subtraction subtraction](https://i.compthesaurus.com/images/026/image-77772-7-j.webp)
Now the difference in numbers has been calculated in the entire column.
Multiplication
To multiply numbers in Excel, you need to do this. In the cell with the total we put the “=” sign, with the mouse mark the multipliers in turn, dividing them with the “*” sign, press “Enter”.
![multiplication multiplication](https://i.compthesaurus.com/images/026/image-77772-8-j.webp)
There can be any number of multipliers. If all factors are in one line, then the expression can be "stretched" over the entire column.
![multiplication multiplication](https://i.compthesaurus.com/images/026/image-77772-9-j.webp)
To multiply a column of numbers by a constant number, you need to do this. Place a constant number in an empty cell. We put the cursor on the area with the future result, we do the rest by analogy with the previous option.
![multiplication constant multiplication constant](https://i.compthesaurus.com/images/026/image-77772-10-j.webp)
The resulting literal expression is correct for this area.
![constant constant](https://i.compthesaurus.com/images/026/image-77772-11-j.webp)
But if we "stretch" the formula, as we did earlier, then it will "go astray." The program will take into account the number from the next cell as a constant.
In order for the program to "know" that the number must always be taken from a certain area, it is necessary to make changes to the original record. In our case, the value with a constant is denoted as E7. We go into the line of formulas and add before E and before 7 the symbol "$", press "enter".
![constant constant](https://i.compthesaurus.com/images/026/image-77772-12-j.webp)
Now the formula can be stretched across the entire column.
![constant constant](https://i.compthesaurus.com/images/026/image-77772-13-j.webp)
We see that in each cell of the column, the first factor is the number from cell E7.
Division
Now let's divide column E by column D (just check if we multiplied correctly by a constant).
![division division](https://i.compthesaurus.com/images/026/image-77772-14-j.webp)
We put the cursor in the cell with the future value, press “equal”, mark E8 and D8, put the division sign “/” between them, press “Enter”, “stretch” the resulting expression.
![division division](https://i.compthesaurus.com/images/026/image-77772-15-j.webp)
Division by a constant is done in the same way as in the case of multiplication.
These are the simplest formulas that might come in handy first. Exel provides tremendous opportunities for creating more complex tasks. The control panel has a "Formulas" section.
![formulas formulas](https://i.compthesaurus.com/images/026/image-77772-16-j.webp)
In it, you can select the value that you need. This is how it works. We put the cursor in an empty cell, go to the "Formulas" section, select the "Mathematical" tab.
![root root](https://i.compthesaurus.com/images/026/image-77772-17-j.webp)
Let's try, for example, to apply the value "root".
![root root](https://i.compthesaurus.com/images/026/image-77772-18-j.webp)
Let's calculate the root of 4. That's right: the root of four is equal to two.
![root root](https://i.compthesaurus.com/images/026/image-77772-19-j.webp)
We create other formulas in the same way. The task is quite within the power of anyone, you just need to figure it out.