Using formulas in Excel cells

  was created specifically for performing numerical calculations. To indicate the calculation program must be written formulas. Formulas are formed, usually of cell addresses, values ​​and mathematical operators. When performing algebraic calculations are followed all the rules: priority multiplication and division operations, the brackets etc.

Excel Formulas

All formulas are introduced with the sign = in front. If you omit the = sign, Excel consider that the cell was inserted text.

The following are the main operators used in Excel.

Arithmetic operators

Operator

Purpose

-

decrease

+

assembly

*

breeding

/

division

%

percent

^

involution

Comparison operators

To compare the results can be used for comparison operators:

Operator

Purpose

=

equal

<

less than

>

higher than

<=

less than or equal to

> =

greater than or equal to

<>

different

To enter a formula to perform the following steps:

1. Select the cell where you have to defend the result of the formula;

2. Write preceded by a formula =.

3. Press the <Enter>

After pressing the <Enter> AndCellulite is not automatically result calculations. If the cell containing the formula is selected again, we find:

• the formula bar is displayed formula;

• the cell is the result.

Example:

A spreadsheet contains the following values:

• A1 cell 7 value;

• B1 cell 3 value.

If the cell C1 write the formula = A1 + B1 after pressing <Enter> Andn 10 cell will display the result (= 7 + 3).

Operation Excel

Excel can be set so as to be displayed in cell formulas. For this you must do the following:

1. Apply command Tools, Options.

2. Select the button View.

3. In the Window Options apply a click in the field Formulas, to mark it.

4. Select the button OK.

View formulas in a spreadsheet cells would be necessary only if all formulas to be viewed at once (for printing or corrections).

To return to the situation that formula results appear in cells prior to the procedure, but that will demarcate field Formulas.

Options View Formulas

Copying formulas

When you copy a formula that is adapted to fit the cell position to be copied.

For example, if you copy the formula = A1 + B1 of cell C1 cell D1It will be adapted for column DBecome = B1 + C1. When copying C2 cell, it becomes = A2 + B2.

If you copy a formula on the same line, all the line of formula cells remain unchanged. Indicators column changes. Over one column to the right column indicators change with a letter, in two columns with two letters etc.

If you copy a formula in the same column, by copying column indicators remain unchanged. Instead change line indicators. With a line below the line increases with 1 indicators over two lines 2 etc.

Example:

Insert formula in cell A5 = B2. Excel knows that A5 cell is a cell that is found used three rows above and one column to the right. By copying the formula in A5 in C8,  Office Excel updated indicators of rows and columns so that the cell C8 will be referred to a cell that is found all three rows above and one column to the right, but from the C8. So the formula in this cell will be = D5.

To copy a formula into a range of cells joined to perform the following steps:

1. Apply click on the cell containing the formula to be copied.

2. Place the mouse cursor in the bottom right corner of the cell.

3. When the cursor changes shape (there is a small cross-shaped cursor), press left mouse button and drag the cursor over the cells to be copied formula.

Formulas can be copied and non-adjacent cells using commands Copy and Paste:

1. Apply click on the cell containing the formula;

2. Apply command Edit, Copy;

3. Apply a click on the cell in which to back;

Apply command Edit, Paste.

Using formulas in Excel cells

About the author

Stealth

Passionate about everything that means gadgets and IT, I write with pleasure stealthsettings.com from 2006 and I like to discover with you new things about computers and operating systems macOS, Linux, Windows, iOS and Android.

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment is processed.