How to make a formula in Excel

The Microsoft Excel Office program has many convenient functions that help not to engage in long calculations before entering data or diagram. To calculate some values, such as addition, subtraction, relationships and others, you can use the initially given formulas. You can make them yourself or choose from the list of existing ones. Learn to insert the formula in stages in this article.

Open the Exel program. There will be a working area in front of you, make sure that the “Home” tab is open.

In an empty line located between the cap of the program and its working area, you will see a field for entering the formula, you will need it after entering arguments, that is, numbers that need to be calculated.

For example, you have a column with certain numbers. In this version - it is 15 and 20.

First, put the first number in the desired cell.

The second number, on this example - 20, put in another cell. It does not make much difference, you will get a column or line.

Click the cursor in the cell where you will need to get the meaning of the expression.

For example, find the sum of two cells. To do this, click on the empty line that you found in the first step. Write there a line of the type “\u003d sums ()” without quotes. Leave the cursor between two brackets.

Click on the first cell.

Put a symbol of ";" In a bracket without quotes and click on the second cell. You will automatically highlight the numbers of cells in the upper line, and between them there will be a symbol of the point with a comma.

Press the Enter key. The sum of two numbers will appear in the cell.

To find out what formulas are, call the master of functions by pressing the left mouse button on the “FX” icon near the formula entering line. In the window that appears, you will see how the signs of addition, subtraction, division and others are recorded. The decryption for each of them will be signed from below.