# How to add in excel formula using shortcut

A free Office suite fully compatible with Microsoft Office

To discover how to add in excel formula, you must look for several guides that contain the information you require. Formulas are usually equations that are responsible for doing calculations in your worksheet. These start with the sign of (=), you can create a simple formula using operator and calculation.

For you to be able to carry out the calculations in your work, it will be essential that you know the best way to add in excel formula easily. This will allow you to get your calculations comfortably with this type of tool.

How to create a formula with cell reference?

If you have time trying to understand how to create a formula with a cell reference, don't worry because, with a few simple steps, you will understand how to add in excel formula function as it should be. Excel has many valuable tools that are necessary for your projects.

1. You must select the cell where the answer is (B3). This will make you begin to understand how to add in excel formulas little by little.

2. Then, you need to write the equal sign (=), practice this step several times to understand it better.

3. You have to calmly write the address of the cell that contains the first number of the equation (B1, as shown in the following example).

4. Write the operator that requires for your formula. For example, write the plus sign (+) to get the expected result.

5. Now, write the cell address that counts the second number in the equation (B3 as an example).

6. To finish, press Enter, and the value will be calculated, and the formula will be displayed in the cell.

How to create a formula using the click method?

This method of how to add in excel formula is relatively easy to learn; indeed, you will want to use it for your new spreadsheet project. This will allow you to calculate the amounts of expenses for your research

1. You have to choose the cell where you will see the answer B4

2. You must type the equals sign (=), then click on the first cell to be placed in the formula, such as A3.

3. Write the operator you require for your formula; for example, you can write the multiplication sign *. Click through the next cell as seen in the example formula B3.

4. To finish, you have to press Enter, and the value can be calculated, and the formula will be displayed in your cell.

How do you edit a formula in Excel?

To become an expert in how to add in excel formula 2019, you must learn to edit a formula. This is a vital process for you to work on your worksheet as you want with the support of how to add in excel formula online.

1. You must click on the cell you want to edit.

2. Insert the cursor where the formula bar is located and edit them as you wish. You can also double-click the cell to edit and view the formula directly from your cell.

3. When you are done, you need to press Enter, or you can also choose the Enter command.

4. You will see the new value in the cell so you can discover how to add in excel formula 2016.

If you could specifically understand how to add in excel formulas, then you can ideally use this tool. For this reason, you will be attracted to gain new knowledge of how to add in excel formula mac.

You must know the WPS Academy website if you are excited to discover several new guides on adding excel formulas. This place has thought of offering you the best way for you to download WPS Office for free.

Was this helpful?

Yes

No

Trending Tutorials

- 1. How to compare two excel sheets and highlight differences
- 2. How to import external data in WPS Spreadsheet
- 3. How to expand cells to fit text in Excel
- 4. How to use the VLOOKUP function across multiple sheets in WPS Office Excel?
- 5. How to insert a check box in WPS Spreadsheet
- 6. How to change date format in a cell