How to use different formulas in excel (Examples, Guide)

August 1, 2022
1.1K Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

A formula is an expression that determines a cell's value. Functions are already present in Excel and are preset formulas. As an illustration, the formula in cell A3 below increases the value of cell A1 by the sum of cell A2 and A1.

For instance, the SUM function in cell A3 below computes the sum of the values in range A1 to A2.

How to enter a formula in excel online, 2016 and 2019

1.Select a cell.Type the equal symbol (=) to indicate to Excel that you wish to input a formula.For instance, enter the equation A1+A2.

2.A helpful hint is to just choose cells A1 and A2 rather than typing A1 and A2.Cell A1's value should be changed to 3.

3.Cell A3's value is updated by Excel automatically. One of Excel's most useful features is this one.

How to edit a formula in excel

Excel displays the value or formula of the selected cell in the formula bar.

4.Click on the formula bar and alter the formula to edit a formula.

5.Press enter.

Operator Precedence in excel

1.Calculations in Excel are performed in a predetermined order. A formula's parentheses indicate which section of the equation will be calculated first. Then computations for division or multiplication are made. Once this is finished, Excel will continue to add and subtract from your formula. See the illustration below.

2.Excel starts by multiplying (A1 * A2). The value from cell A3 is then added to this outcome by Excel.One more example:

3.Excel begins by adding the part in parenthesis (A2+A3). It then multiplies this outcome by the quantity in cell A1.

Copy/Paste a formula in excel

Excel automatically modifies the cell references for each new cell the copied formula is pasted into when you copy a formula. Follow these instructions to gain an understanding of this.Put the following formula into cell A4.

4.Right-click on cell A4 and choose Copy (or press CTRL + C)…

5....then, right-click on cell B4 and choose Paste from the list of options that appears (or press CTRL + v).

6.Additionally, you can drag the formula to cell B4. Choose cell A4, then move it to cell B4 by clicking on the cell's lower right corner. This is considerably simpler and produces the same outcome!

7.Result:

Note: This above written article is an attempt to show you how to use different formulas in excel online, 2016 and 2019, in both windows and mac.You just need to have a little understanding of how and which way things work and you are good to go. With having this basic knowledge or information of how to use it, you can also access and use different other options on excel or spreadsheet. Also, it is very similar to Word or Document. So, in a way, if you learn one thing, like Excel, you can automatically learn how to use Word as well because both of them are very similar in so many ways. If you want to know more about WPS Office, you can download WPS Office to access, Word, Excel, PowerPoint for free.