How to Enter a Formula in Excel Office 365 ~ Easy Tutorial!!
Tags: excelpreface, excelbasics, exceltutorials, howtoentertheformula
Published: 2020-12-30 15:53:21

---
title: How to Enter a Formula in Excel Office 365 ~ Easy Tutorial!!
published: true
date: 2020-12-25 12:40:07 UTC
tags: ExcelPreface,ExcelBasics,ExcelTutorials,Howtoentertheformula
canonical_url: https://geekexcel.com/how-to-enter-formula-in-excel/
---

So far, we have learned the simple steps to calculate the[average](https://geekexcel.com/how-to-use-excel-average-function-in-office-365-with-examples/), [sum](https://geekexcel.com/sum-function/), [largest](https://geekexcel.com/excel-formulas-to-get-the-largest-value-with-criteria/) and [smallest](https://geekexcel.com/how-to-use-excel-small-function-in-office-365-with-examples/) values from a range without using any formula in Excel. Now, we are going to see **how to enter a formula in Excel**. Let’s get started!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## Jump To:

- [**What is Formula?**](#1)
- [**Steps to Enter a Formula**](#2)
- [**Conclusion**](#3)

## What is Formula?

The **formula** is a simple **statement** made up of ‘operands’ and ‘[operators](https://geekexcel.com/excel-vba-operators/)‘. In other words, a formula is an expression telling the computer what mathematical operation to perform upon a specific value

- For example, you need to add the two numbers means, what would you do? You just use the simple statement like [Sum](https://geekexcel.com/sum-function/)=A+B.
- Here, there are two operators A and B.
- The operator is plus sign (+) and the result is sum.

**Note: ** In Excel, the formula is always starts with an equal sign. If you do not begin your formulas with an equal sign, Excel will treat it as a string data type.

## Steps to enter a formula:

Let’s follow the below steps to know how to enter the formula in Excel.

- First, you need to select the cell where you need to enter the formula.

![Select a cell](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Select-a-cell-3.png)<figcaption id="caption-attachment-20405">Select a cell</figcaption>

-  Here, you must enter the equal sign (=).

![Equal sign](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Equal-sign.png)<figcaption id="caption-attachment-20406">Equal sign</figcaption>

- Then you need to type the value, formula or any other function in the cell.
- Let’s see the below image, here we will enter the formula such as (B3+B4+B5+B6).

![Enter the formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Enter-the-formula.png)<figcaption id="caption-attachment-20407">Enter the formula</figcaption>

- After applying the formula, you can also see it in the formula bar section.
- Now click the **ENTER** button, it will display the result in the selected cell.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Result-14.png)<figcaption id="caption-attachment-20409">Result</figcaption>

## Conclusion:

From this short tutorial, you can easily understand the simple steps of how to enter the formula in Excel. If you have any **questions,** feel free to **comment**. Thank you so much for visiting our site!!

### Read Ahead:

- **[Excel VBA Decisions in Office 365 ~ Easy Tutorial for You!!](https://geekexcel.com/excel-vba-decisions-in-office-365-easy-tutorial-for-you/)**
- **[Excel Formulas to Sum the Values if Cells are Not Equal to Certain Value!!](https://geekexcel.com/excel-formulas-to-sum-the-values-if-cells-are-not-equal-to-certain-value/)**
- **[Formulas to Sum the values that Equal to One of Many Things!!](https://geekexcel.com/excel-formulas-to-sum-the-values-that-equal-to-one-of-many-things/)**