Excel Insert Function

Method #1 – Using Equal To Sign

We all know all the formulas in Excel, starting with an equal (=) sign. We think this is what our early Excel coach must have taught us. So now, let us begin by inserting the formula in Excel with an equal sign first.

#1 – Calculations without Inbuilt Formulas

Now, we can see the result of 10+20 in cell A1. We can see the formula in the formula bar.

  • Now, look at the calculation of 10 + 20 = 30 in excel. First, open the equal sign in cell A1. Type 10+20. Now, press the “Enter” button. It will perform the calculation just like a calculator.

#2 – Calculations without Inbuilt Formulas: Based On Cell Values

We have learned how to enter the formula in Excel by using equal and supply values directly to the formula itself. Now, we may see how to apply formulas for cells.

In cell A1, we have the number 10. In cell A2, we have the number 20. Finally, in cell A3, we want the summation value of these two.

Open equal sign in cell A3 and select the A1 cell.

After selecting the cell A1 type plus (+) sign and select the cell A2.

Then, press the “Enter” key to see the Excel formula result.

It is a dynamic formula because if any change happens in cells A1 and A2, it will impact cell A3. After all, the A3 cell contains the formula completely dependent on A1 and A2 cells.

Method #2 –  Using Insert Function Dialog Box

Example #1 – Excel Built-in Formulas

Take the same example as cells A1 and A2. We must apply the built-in SUM function to get the total. In A3, after an equal sign, type the letter S, and we will get all the formulas that begin with S.

Next, enter the letter U. Now, we will see all the formulas that start with SU.

Like this, we can apply built-in formulas in Excel. Of course, remembering 450+ formulas in Excel is not an easy task, but we can insert formulas by using the Excel INSERT FUNCTION option.

Click on this fx option to open the INSERT FUNCTION dialogue box.

Here we can search for the formula we want to use. If we are not sure which formula to apply, we can enter a brief description of the formula. For example, if we go to SUM cellsSUM CellsThe SUM function in excel adds the numerical values in a range of cells. Being categorized under the Math and Trigonometry function, it is entered by typing “=SUM” followed by the values to be summed. The values supplied to the function can be numbers, cell references or ranges.read more, we can write sum cells, giving us the list of excel formulasList Of Excel FormulasThe term “basic excel formula” refers to the general functions used in Microsoft Excel to do simple calculations such as addition, average, and comparison. SUM, COUNT, COUNTA, COUNTBLANK, AVERAGE, MIN Excel, MAX Excel, LEN Excel, TRIM Excel, IF Excel are the top ten excel formulas and functions.read more.

Once we get the recommended formulas, click on the function we want to use.

Now we need to specify which cells we want to use to SUM.

  • Number 1 will be our first number, which is there in the cell A1.Number 2 will be our second number, which is there in the cell A2.

Select both the numbers.

Now, look at the options we have. It has opened up one more Number 3 slot to select the third number, if any. And also, we can see the resulting review here only.

Click on OK to complete the formula, and we will have a result in the A3 cell.

Example #2 – Using Insert Function Dialog Box

Take a look at one more example. I have four values.

In cell B6, we want to calculate the AVERAGE values of the above four numbers in cells B2, B3, B4, and B5.

Step 1: We must first select cell B6 and click on fx.

Step 2: Now, we will see the INSERT FUNCTION dialog box.

Step 3: Now, type AVERAGE in the search box and click on “GO.” We may see the AVERAGE function.

Step 4: Then, select the AVERAGE function. We may see the dialog box.

Step 5: Select the first two cell values, i.e., B2 & B3. It will open up another cell referenceCell ReferenceCell reference in excel is referring the other cells to a cell to use its values or properties. For instance, if we have data in cell A2 and want to use that in cell A1, use =A2 in cell A1, and this will copy the A2 value in A1.read more.

Step 6:  Like this, we must select all the values we want to find the average.

We can now see the result preview and what cells we have chosen. Click on “OK” to complete the formula.

We have the AVERAGE function is cell B6.

Things to Remember

  • We must limit the INSERT FUNCTION only for our understanding. Once we are comfortable with formulas, type them directly into the cell.We can also INSERT FUNCTION under the FORMULA tab.We can INSERT FUNCTION under Autosum drop down by clicking on “More Functions.”The shortcut key to INSERT FUNCTION in Excel is “Shift + F3.”

This article is a guide to Insert Function in Excel. We discuss inserting formulas and functions in Excel using the equal to sign and Insert function dialog box, practical examples, and a downloadable Excel template. You may learn more about Excel from the following articles: –

  • Search Box in ExcelInsert Page Break in ExcelHow to Insert New Worksheet in Excel?Insert Date in Excel