Excuse me, who knows all the commands of excel calculation formula?
Usage: Returns the average value of the columns in a database or data list that meet the specified conditions. Syntax: DAVERAGE (database, field, standard)
Parameters: Database constitutes a list or a range of cells of the database. Field specifies the data column used by the function. The standard is a group.
Cell range.
2. Data counting
Usage: Returns the number of cells that meet the given conditions and contain numbers in the specified field of a database or data list. Syntax: DCOUNT(Database, field, criteria) parameters: Database constitutes a list or cell area of the database. Field specifies the data column used by the function. Criteria is a set of cell ranges that contain a given condition.
3.DCOUNTA
Usage: Returns the number of non-empty cells in the specified field of a database or data list that meet the given conditions. Syntax: DCOUNTA (database, field, condition)
Parameters: Database constitutes a list or a range of cells of the database. Field specifies the data column used by the function. The standard is a group.
Cell range.
4.DGET
Objective: To extract a single value that meets the specified conditions from a data list or database. Syntax: DGET(Database, field, criteria) parameters: Database constitutes a list or cell area of the database. Field specifies the data column used by the function. Criteria is a set of cell ranges that contain a given condition.
5.DMAX
Usage: Returns the maximum value in a cell that meets a given condition in a specified column of a data list or database. Syntax: DMAX (database, field, standard)
Parameters: Database constitutes a list or a range of cells of the database. Field specifies the data column used by the function. The standard is a group.
Cell range.
6.DMIN
Usage: Returns the smallest number in a cell that meets a given condition in a specified column of a data list or database. Syntax: DMIN (database, field, standard)
Parameters: Database constitutes a list or a range of cells of the database. Field specifies the data column used by the function. The standard is a group.
Cell range.
7. Data products
Usage: Returns the product of the values in the cells that meet the given conditions in the specified column of a data list or database. Syntax: DPRODUCT (database, field, condition) parameters: same as above.
8.DSTDEV
Objective: To estimate the standard deviation of the sample population by taking the numbers in the columns that meet the specified conditions in the list or database as samples. Syntax: DSTDEV (database, field, condition) parameters: same as above 3.
9.DSTDEVP
Parameter: Can you count mites? Trouble with badgers? Brother school? Hey? What? ピ? Mechanical neon? Swelling? Is it fluorene? What's your plan? Hey?
Syntax: DSTDEVP (database, field, condition) parameters: same as above.
10.DSUM
Usage: Returns the sum of the numbers in the cells that meet the given conditions in the specified column of a data list or database. Syntax: DSUM (database, field, condition) parameters: same as above.
1 1.DVAR
Objective: To estimate the variance of the sample population by taking the numbers in the cells that meet the given conditions in the specified column of a data list or database as samples. Syntax: DVAR (database, field, condition) parameters: same as above.
12.DVARP
Usage: Take the numbers in the cells that meet the given conditions in the specified column of the data list or database as the sample population, and calculate the variance of the population.
Syntax: DVARP (database, field, condition) parameters: same as above.
13.GETPIVOTDATA
Objective: To return the data stored in the PivotTable. If the summary data in the report is visible, you can use the GETPIVOTDATA function to retrieve the summary data from the PivotTable report. Syntax: GETPIVOTDATA(pivot_table, name) Parameters: Data_field is the name of the data field containing the data to be retrieved (in quotation marks). Pivot_table is a reference to any cell, cell range or defined cell range in the PivotTable. This information is used to determine which PivotTable contains the data to be retrieved. Field 1, project 1, field 2 and project 2 are 1 to 14. The field names and project names used to describe the retrieved data can be arranged in any order.
(2) Date and time function
1. Date
Usage: Returns the serial number representing a specific date. Syntax: DATE(year, month, day) parameters: year is one to four digits, and this parameter is interpreted according to the date system used. By default, Excel for Windows uses the 1900 date system, while Excel for Macintosh uses the 1904 date system. Month stands for the middle month of each year. If the month entered is greater than 12, the addition operation will start from 1 month of the specified year. Day means a day in a month. If day is greater than the maximum number of days in the month, it will be accumulated from the first day of the specified month. Note: Excel saves dates in serial number order, so you can calculate them. If the workbook uses the date system of 1900, Excel will save the date of 1900 1 as the serial number of 1. Similarly, the date 1998 65438+ 10/will be saved as serial number 35796, because the date is 1 90065438+1 01.
35795 days. For example, if the date system of 1900 is adopted (Excel defaults), the formula "= date (200 1, 1)" returns 36892.
2. Date value
Usage: Returns the serial number of the date indicated by date_text. The main purpose of this function is to convert the date expressed in words into a serial number.
Syntax: DATEVALUE(date_text) parameters: date_text is the text representing the date in Excel date format. In the date system of 1900, date_text must be a date between 1900 1 October and 1 February (999); In the 1904 date system, date_text must be a date between 1904 1 in February and 1 in 999. If date_text is out of the above range, the function DATEVALUE
Returns the error value #VALUE! . If the time in the parameter date_text is omitted, the function DATEVALUE uses the current time of the internal clock of the computer system, and the time information in date_text will be ignored. For example, the formula "=DATEVALUE("200 1/3/5") "returns 36955, and DATEVALUE("2-26") returns 36948.
3. Day
Usage: Returns the number of days of the date represented by serial number (integer 1 to 3 1) and integer 1 to 3 1. Syntax: Day (Serial Number)
Parameter: Serial_number is the date and date to be searched, which can be entered in various ways: quoted text string (such as "1998/0 1/30") and serial number (such as 1900).
1998 1.30), and the results of other formulas or functions (such as datevalue ("1998/1/30").
For example, the formula "= day ("20011/27 ")" gives 27, and =DAY(35825) gives 30, = date value ("20011/25").