Maybe you could take a few classes during school ExcelIts tables and formulas, but all in a general and very basic way, however, over time and when people reach adulthood, they see that it is important to know how to behave program Microsoft.

But technology seems to have a solution, it turns out is a website that helps you generate formulas automatically, And it will be of great help for work and other activities.

When entering the site, the user will find three options, the first button is to generate Google Sheets formulas, which is the spreadsheet version of this company, the next tab invites donations to the site creator and The third field will be used to create Excel formulas. In other words, the platform also offers more support.

Have access to formulas that, according to the site, are generated by a artificial intellect, It will be necessary to register by e-mail to type the necessary operation, and finally, after generating the formula, all that remains is to copy it and transfer it to the table.

It should be noted that the site emphasizes that it is only possible to calculate formulas that can be performed in Excel, otherwise it will be marked as an error. This is the web address of the platform: https://excelformulabot.com/excel-espanol

On the other hand, if what you want is to be able to perform certain formulas on your own and without relying on artificial intelligence like the one mentioned, probably because it’s more practical than searching the web, there’s no other option but to learn the commands.

So while you have the help of this type of technology, it will also be useful to know some formulas and apply them manually, these are the most well-known.

addition

Summarization is the most necessary and useful task in this program, because the result can be obtained by grouping several cells. You only need to enter the command plus the cells you want to add, for example =SUM(A1:A10), which means it will add 1 to 10 from the box.

deduction

Those who do personal finance in Excel spreadsheets will know how important it is to learn how to subtract using commands instead of looking in the toolbar, so for this operation you will have to register in the field in which you want to see. Result other “=” and subtracted values, for example, if you want to subtract cells A1 and cells B6, you must register =A1-B6.

Yes

This is a basic formula for teachers, because if they take the class sheets digitally, they can determine who passed or failed the exam, for example, they can determine the result based on what the conditions are.

So, back to the class sheet example, you can decide that the cell says “failed” if the number is less than 3, ie enter the following command in the Fx bar. =IF(A2<3, "passed", "failed").

However, assuming that cell A2 contains the student name “Carlos” and his grade, placing the conditioner “<3" instructs the system to place "Carlos" in the pass or fail column. matter according to its result.

Continue reading: