EXCEL commonly used formulas?
Excel commonly used formulas are as follows for reference:
1, AVERAGE return to the average of the selected database items
2, COUNT calculates the number of cells containing the number of database
3, COUNTA calculates the number of non-empty cells in the database
4, DGET from the database Extract from the database to meet the specified conditions of a single record
5, MAX return to the maximum value of the selected database items
6, MIN return to the minimum value of the selected database items
7, PRODUCT multiplied by the value of a specific field (the record in this field for the database to meet the specified conditions of the record)
8, STDEV based on the database STDEVP calculates the standard deviation based on the sample total of the selected items in the database
10. SUM sums the numbers in the field columns of the records in the database that satisfy the conditions
11. VAR estimates the variance based on the sample total of the selected items in the database
12. VARP calculates the variance based on the sample total of the selected items in the database
13. database of selected items in the sample as a whole to calculate the variance
13, GETPIVOTDATA return to the data stored in the pivot table
Extension:
1, LEFT function function name: LEFT main function: from a text string of the first character to start, the number of characters intercepted specified. Format: LEFT (text, num_chars) parameter description: text on behalf of the string of characters to be intercepted; num_chars on behalf of the given number of interceptions.
2, RIGHT function function name: RIGHT main function: from a text string of the last character, intercept the specified number of characters. Use Format: RIGHT (text, num_chars)
3, Excel is a very important piece of software in office automation, Excel function is a built-in Excel function. Excel function contains a total of 11 types of functions, respectively, database functions, date and time functions, engineering functions, financial functions, information functions, logic functions, Query and reference functions, math and trigonometric functions, statistical functions, text functions and user-defined functions.