How To Write Formulas in Excel Program?

In this tutorial, I will explain the simple steps on how to write formulas in Excel program. Writing formulas in Excel is a very important and basic skill that helps you to perform complex calculations, manipulate data, and automate tasks within spreadsheets.

Excel’s formula allows you to enhance the full potential of your data by performing various mathematical, logical, and statistical operations. Whether you’re a business analyst analyzing sales charts, a student calculating grades, or a project manager managing budgets, the Excel formulas are essential.

Understanding how to write formulas in Excel application not only streamlines your tasks but also enhances your efficiency and decision-making thoughts.

How to Write Formulas in Excel Program?

Here are the steps on how to make formulas in Excel program:

Step 1: Select a Cell:

Begin by selecting the cell where you want the result of your formula to appear. Click on the desired cell to highlight it; this is where the output of your calculation will be displayed.

Step 2: Start the Formula:

Begin your formula with an equal sign (=). Typing this sign tells Excel that you are entering a formula, not just text.

Step 3: Enter the Formula:

Now, enter the mathematical operation you want to perform. For example, if you want to add two numbers, type the addition symbol (+). Use (-) for subtraction, (*) for multiplication, and (/) for division. For more complex operations, use functions like SUM, AVERAGE, MAX, MIN, etc.

Mathematical operators, such as “+” (for addition) and “*” (for multiplication),

Example: Click in “D3” and write this formula: =B3+C3. It will add the values in cells B3 and C3. See in the above screenshot.

Step 4: Select Cells or Enter Values:

After entering the operation, select the cells you want to include in your calculation. Click on the first cell, and if you want to include a range, drag your cursor to select the cells. Alternatively, you can manually enter the values you want to use in the formula.

Step 5: Complete the Formula:

After selecting cells or entering values, close the formula by either pressing Enter on your keyboard or clicking on another cell. Excel will automatically calculate the formula, and the result will be displayed in the selected cell.

Step 6: Edit or Copy the Formula (Optional):

If you want to edit the formula, click on the cell containing the formula, and then edit the formula directly in the formula bar at the top of the Excel window. If you want to apply the same formula to other cells, you can copy and paste it. Click on the cell with the formula, copy it (Ctrl+C or Command+C), select the destination cells, and paste the formula (Ctrl+V or Command+V).

By following these steps, you can create various formulas in Excel to perform calculations, manipulate data, and analyze information, making your spreadsheet tasks more efficient and accurate.