How all Excel formulas are used in a spreadsheet

Who I am
Catherine Le Nevez

Author and references

Excel formulas are a very important aspect within the program itself, since despite containing a large dynamism with respect to its functions, they represent the functional part of the tool.

The Microsoft company has been improving its creation every day, expanding the range of calculations that can be performed within the sheet .

In this way, the people who use the program have greater ease of use, and in turn have access to various computing systems.

Learn to using Excel is quite simple , so in this article you will see how to make a formula and which are the most important or common ones to use.

Excel formulas: step by step how to create a formula

In relation to what was mentioned at the beginning, the use of these functions are those that allow you to fulfill the purpose for which the program was created.

Microsoft Excel itself has a button in its toolbar that bears the name of " Formulas ", which allows you to select which operation you want to perform.

If you want to learn a manually create Excel formulas , it's really very simple and you get it as follows:

  • To start, click on the cell where you want to insert the formula created, which is the one that will allow you to view the result.
  • Once there, start typing the equal sign " = ", which will be accompanied by the cell or range of cells that will be part of the operation. Between each of them must be a symbol, which is what defines what the values ​​will do to each other from the point of view mathematical.
  • After that, all you have to do is press the " Submit "to see how the calculation result automatically appears inside the cell.
Read How to Delete Saved Snapchat Messages in Few Steps

Excel formulas: basic mathematical operations

By basic I usually refer to those calculations that do not require the use of additional or very complex functions to complete.

To use them, simply select the number of cells that will play the role of value and determine which mathematical symbol will perform the operation. This style of basic formulas does refers directly to the calculations of addition, subtraction, multiplication and division .

Each of these Excel formulas has a characteristic symbol which is interpreted by the program. So you know what to do.

These do not differ from the universally known ones, because to add the plus symbol "+" is used, to subtract the minus symbol "-", to multiply an asterisk "*" and to divide a diagonal "/".

The following example will help you understand better, since applying the formula of "= A2 + B3" you determine that the values ​​of these cells are the ones that will be summed.

The same happens with the other basic operations, just change the symbol and you can do it. Likewise, the number of cells that make up the formula increases.

Other important operations within Excel

Excel formulas are very broad in terms of content and type of calculation trained to perform. Therefore, among them we will find the following types of important operations:

Calculate the VAT of a product

To apply it, it is sufficient to know the price of the product and the percentage on which the VAT is based in the country to be calculated. The formula is applied as follows: "= product price * (1 + VAT)".

Arithmetic mean

This formula calculates the average value within the range of selected cells. In statistics it is established as the arithmetic mean: “= AVERAGE (number of cells)”.

Read What Is Referral In Credit Card Processing System And What Does It Mean?

Learn to operate within the sheets of calculation Microsoft Excel it is not a difficult task for those who try it, as it only requires dedication and understanding.

The range of mathematical operations enabled within this program is very broad. So this tool will continue to be very useful whenever you need to set up a function for your workspace or school assignment.

add a comment of How all Excel formulas are used in a spreadsheet
Comment sent successfully! We will review it in the next few hours.