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 formula
Then, complete the formula. To do so, there are different methods available. You can write a series of numbers and operators:
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 cel
Typing a letter to choose from a list of spreadsheet functions:Formula 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 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.