OFFICE参数(国外英语资料).doc

OFFICE参数(国外英语资料) ABS to find the absolute value of the parameter. Data calculation 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, and returns FALSE. Logical judgment LEFT starts with the first character of a text string and intercepts the specified number of characters. Intercept data LEN statistics the number of characters in text strings. Character statistics MATCH returns the corresponding position of the element in the array that match