How to add formulas in Excel

Situatie

Someone needs to create formulas in Excel.

Solutie

Let’s take an example of a simple formula.

1.On the worksheet, click the cell in which you want to enter the formula.
2.Type the = (equal sign) followed by the constants and operators (up to 8192 characters) that you want to use in the calculation.

For our example, type =1+1.

Notes:

Instead of typing the constants into your formula, you can select the cells that contain the values that you want to use and enter the operators in between selecting cells.

Following the standard order of mathematical operations, multiplication and division is performed before addition and subtraction.

3.Press Enter (Windows) or Return (Mac)
Let’s take another variation of a simple formula. Type =5+2*3 in another cell and press Enter or Return. Excel multiplies the last two numbers and adds the first number to the result.

Tip solutie

Permanent
Share ..

Voteaza

(12 din 34 persoane apreciaza acest articol)

Lasă un răspuns

Adresa ta de email nu va fi publicată. Câmpurile obligatorii sunt marcate cu *

We are all close together

A problem, a question, an emergency?
Do not hesitate to visit the help centre, we can help you.

Copyright © 2020 Askit. All rights reserved

Suport Tehnic