How to make formulas in Excel

To use a formula in Excel, you must follow the process described below. First, select any cell and type in it the equal symbol (=) to tell the program that we are going to work with a formula:

Starting a formulaStarting a formula

Then, complete the formula. To do so, there are different methods available. You can write a series of numbers and operators:

Simple operation in a cellSimple operation in a cell

Use the mouse to select other cells, inserting an operator between them, and clicking on a third cell (this one is where the result will be displayed):

Adding up a range in a third celAdding up a range in a third cel

Typing a letter to choose from a list of spreadsheet functions:

Formula based on a functionFormula based on a function

If you choose this method, you will have to complete the formula using numbers, cell identifiers, and operators by pressing Enter. If you want to complete a formula that uses a function, enter the required information (usually a description of what it does), and press Enter:

Function completed with a range of cellsFunction completed with a range of cells

Formulas are equations that let the user perform automatic calculations, return information, manipulate the contents of other cells, and so on. This is a good way to automate some of the work since it lets us cross-reference data and obtain the result offered by the combination of the information.

A formula is composed of the following elements:

  • Constants or text: constants are a number, while text must be enclosed in quotation marks.
  • Cell references: they can replace constants and are references to the cells that have the value we want to use.
  • Operators: they are the symbols of the mathematical operators (addition, subtraction, multiplication, and so on).
  • Excel functions: formulas that let us use predefined functions used by this software.