Post by account_disabled on Dec 23, 2023 4:51:36 GMT -5
You have come this far, you are ready to start learning one of the most interesting parts: formulas. As we have seen, a formula is stored in a cell. It governs the value that will be displayed at that address and can use information from various places for that, that is, external references or links. There are many possible functions, which can be combined in infinite ways to automate — or at least simplify — virtually any task. To understand the variety of operations available, let's look at their main categories: String/Text: To join, separate, combine or manipulate blocks of text or their letters separately.
Date/Time: Operations related to the calculation of time, interval Special Data between dates, business days and the identification of days, weeks and months. Mathematics /Trigonometry: Beyond arithmetic operations, you can calculate complex equations, constants, generate random numbers and change rounded numbers, convert units and operations with angles. Statistics: For the analysis of sets. Automatically identifies percentis, means, medians, distributions, counts, permutations and others. Logical functions: Allows other functions to be combined and analyzed based on a rule described by the user. Information functions: To endorse the result of other functions.
They can tell if a cell is blank, if there is an error, such as a date or text, for example. They also identify and manipulate format identifiers (date, time, percentual etc.). Database: Deliver values related to a group of cells (range). They can be used for counts or number of elements. Financial: They are used to simplify the calculation of interest, depreciation, investment periods or number of payments, for example. Engineering: Basically used to convert numbers between their various forms of representation, such as binary, octal, and other units of measurement.
Date/Time: Operations related to the calculation of time, interval Special Data between dates, business days and the identification of days, weeks and months. Mathematics /Trigonometry: Beyond arithmetic operations, you can calculate complex equations, constants, generate random numbers and change rounded numbers, convert units and operations with angles. Statistics: For the analysis of sets. Automatically identifies percentis, means, medians, distributions, counts, permutations and others. Logical functions: Allows other functions to be combined and analyzed based on a rule described by the user. Information functions: To endorse the result of other functions.
They can tell if a cell is blank, if there is an error, such as a date or text, for example. They also identify and manipulate format identifiers (date, time, percentual etc.). Database: Deliver values related to a group of cells (range). They can be used for counts or number of elements. Financial: They are used to simplify the calculation of interest, depreciation, investment periods or number of payments, for example. Engineering: Basically used to convert numbers between their various forms of representation, such as binary, octal, and other units of measurement.