1, database function
When you need to analyze whether the values in the data list meet certain conditions, you can use the database worksheet function.
2. Date and time function
Date and time functions can be used to analyze and process date and time values in formulas.
3. Engineering function
The engineering worksheet function is used for engineering analysis. Most of these functions can be divided into three types: functions for dealing with complex numbers, functions for numerical conversion between different digital systems (such as decimal, hexadecimal, octal and binary), and functions for numerical conversion in different measurement systems.
4. Finance function
Financial functions can perform general financial calculations, such as determining the payment of loans, the future value or net present value of investments, and the value of bonds or coupons.
5. Information function
You can use the information sheet function to determine the type of data stored in a cell. The information function contains a set of worksheet functions named IS, which returns TRUE when the cell meets the condition.
6. Logical function
Logical functions can be used to judge whether the value is true or not, or to conduct composite tests.
7. Query and reference function
When you need to find a specific value in a data list or table, or you need to find a reference to a cell, you can use the query and reference worksheet function.
8. Mathematics and trigonometric functions
With math and trigonometric functions, you can handle simple calculations, such as rounding numbers, summing values in a cell range, or complex calculations.
9. Statistical function
The statistical worksheet function is used for statistical analysis of the data area. For example, the statistical worksheet function can provide information about a straight line drawn by a set of given values, such as the slope and Y-axis intercept of the straight line, or the actual point values that make up the straight line.
10, text function
Text functions allow you to manipulate text strings in formulas.
1 1, user-defined function
If you want to use a particularly complicated calculation in a formula or calculation, but the worksheet function can't meet your needs, you need to create a custom function. These functions are user-defined and can be created using Visual Basic for Applications.