MS EXCEL 2016(UNDERSTANDING THE FORMULA)

HELLO EVERYONE!

In This Tutorial We are going to talk about the most important feature of Excel which is Formula's

So Let's Start !

First of all we are going to understand the basics of the Formula,

Excel formulas are useful in all types of spreadsheet applications. This tutorial includes information on creating formulas and uses real-world scenarios for practice.

Formulas work almost exactly the same way in most spreadsheet programs, so you can work along with this tutorial even if you don't have Excel. These skills will work in Google Sheets, LibreOffice, OpenOffice, and many other spreadsheet programs.

One of the most powerful features in Excel is the ability to calculate numerical information using formulas. Just like a calculator, Excel can add, subtract, multiply, and divide.

Simple Formula-

Mathematical operators

Excel uses standard operators for formulas, such as a plus sign for addition (+), a minus sign for subtraction (-), an asterisk for multiplication (*), a forward slash for division (/), and a caret (^) for exponents.


All formulas in Excel must begin with an equals sign (=). This is because the cell contains, or is equal to, the formula and the value it calculates.

Cell Reference

While you can create simple formulas in Excel manually (for example, =2+2 or =5*5), most of the time you will use cell addresses to create a formula. This is known as making a cell reference. Using cell references will ensure that your formulas are always accurate because you can change the value of referenced cells without having to rewrite the formula.

In the Above picture the Formula in Cell A3 refers to the value in cell A1 plus the value in the cell A2.

In the above picture ,the Formula calculates and displays the answer to the equation A1 plus A2.


Note-By combining a mathematical operator with cell references, you can create a variety of simple formulas in Excel. Formulas can also include a combination of cell references and numbers.


To Create A Formula-

1.Select the cell that will contain the formula.

2.Type the equals sign (=). Notice how it appears in both the cell and the formula bar.

3.Type the cell address of the cell you want to reference first in the formula.

4.Type the mathematical operator you want to use

5.Type the cell address of the cell you want to reference second in the formula. A red border will appear around the referenced cell.

6.Press Enter on your keyboard. The formula will be calculated, and the value will be displayed in the cell.

Note-If the result of a formula is too large to be displayed in a cell, it may appear as pound signs (#######) instead of a value. This means the column is not wide enough to display the cell content. Simply increase the column width to show the cell content.

Modify Values With Cell Reference-

The true advantage of cell references is that they allow you to update data in your worksheet without having to rewrite formulas.

Simply change the cell values simultaneously and you will see the instant change in the result too.

Its that simple.

Creating Formula Using Point & Click Method-

Rather than typing cell addresses manually, you can point and click on the cells you want to include in your formula. This method can save a lot of time and effort when creating formulas.

1.Select the cell that will contain the formula.

2.Type the equals sign (=).

3.Select the cell you want to reference first in the formula.

4.Type the mathematical operator you want to use.

5.Select the cell you want to reference second in the formula.

6.Press Enter on your keyboard. The formula will be calculated, and the value will be displayed in the cell.

Note-Formulas can also be copied to adjacent cells with the fill handle, which can save a lot of time and effort if you need to perform the same calculation multiple times in a worksheet.

Editing A Formula-

Sometimes you may want to modify an existing formula. In the example below, we've entered an incorrect cell address in our formula, so we'll need to correct it.

1.Select the cell containing the formula you want to edit.

2.Click the formula bar to edit the formula. You can also double-click the cell to view and edit the formula directly within the cell.

3.A border will appear around any referenced cells.

4.When you're finished, press Enter on your keyboard or select the

Enter command in the formula bar.

5.The formula will be updated, and the new value will be displayed in the cell.

That,s It For Now!

I Will Keep Updating!

Stay Updated!