函数用法new（Function usage NEW）.docVIP

函数用法new（Function usage NEW） Displays the current system time: =today () DATE gives the date of the specified value. Display date The DATEDIF calculation returns the difference between the two date parameters. Calculated days DAY calculates the date or number of days in the specified date or reference cell in the parameter. Calculated days A formula is a combination of one or more functions. The AND and operation returns the logical value and returns the logic TRUE only if the result of the parameter is true (TRUE), and returns the logical false (FALSE). Conditional judgment AVERAGE calculates the arithmetic mean of all arguments. Data calculation COLUMN showed that the reference cell header number. Display position CONCATENATE connects data from multiple characters, text, or cells to a single cell. Character merging COUNTIF counts the number of cells in a cell area that match the specified criteria. Conditional statistics DATE gives the date of the specified value. Display date The DATEDIF calculation returns the difference between the two date parameters. Calculated days DAY calculates the date or number of days in the specified date or reference cell in the parameter. Calculated days DCOUNT returns the number of cells in the database or list of columns that satisfy the specified criteria and contain numbers. Conditional statistics FREQUENCY returns the frequency distribution of data in a region in a vertical array. Probability calculation IF returns the calculated result of the corresponding conditional triggering according to the true and false results of the logical judgment of the specified condition. Condition calculation INDEX returns the element value in a list or array that is determined by the index number of the row number and column number. Data location INT values are rounded down to the nearest integer. Data calculation ISERROR is used to test whether the value returned by the function type is wrong. If there is a mistake, the function returns TRUE, an