ABS calculates the absolute value of parameters. Data calculation

The AND operation returns logical false, and only when all the results with parameters are logical true will logical true be returned, and vice versa. Conditional judgment

AVERAGE calculates the arithmetic average of all parameters. Data calculation

Column displays the column label value of the reference cell. display position

CONCATENATE connects multiple character texts or data in a cell and displays them in a cell. Character merging

COUNTIF calculates the number of cells in the cell range that meet the specified conditions. Conditional statistics

DATE gives the date of the specified value. Display date

The DATEDIF calculation returns the difference between two date parameters. Counting days

The date specified in the daily calculation parameter or the number of days in the reference cell. Counting days

DCOUNT returns the number of cells in a column of a database or list that meet the specified conditions and contain numbers. Conditional statistics

FREQUENCY returns the frequency distribution of data in a region as a vertical array. Probability calculation

IF judges whether the result is true or false according to the logic of the specified condition, and returns the calculation result triggered by the corresponding condition. Conditional calculation

INDEX returns the value of an element in a list or array, which is determined by the index value of the row number and column number. Data positioning

INT rounds the value down to the nearest integer. Data calculation

ISERROR is used to test whether the return value of the function is wrong. If there is an error, the function returns TRUE, otherwise it returns FALSE. Logical judgment

LEFT starts with the first character of the text string and intercepts a specified number of characters. Intercept data

LEN counts the number of characters in a text string. Character statistics

MATCH returns the corresponding position of the element in the array that matches the specified value in a specified way. Matching position

MAX looks for the maximum value in a set of numbers. Data calculation

MID starts at the specified position of the text string and intercepts the specified number of characters. Character interception

Find the smallest value in a set of numbers. Data calculation

Find the remainder of the division of two numbers. Data calculation

MONTH finds the month of a specified date or a date in a reference cell. Date calculation

Now give the current system date and time. Show date and time

Or only when all parameter values are logically false, the logical "false" of the result is returned, otherwise the logical "true" is returned. Logical judgment

RANK The ranking of a value in the list of return values relative to other values. Data classification

RIGHT starts with the last character of the text string and intercepts a specified number of characters. Character interception

SUBTOTAL returns the subtotal in a list or database. subtotal

SUM calculates the sum of a set of values. Data calculation

SUMIF calculates the sum of values in a range of cells that meet the specified conditions. Conditional data calculation

TEXT converts the corresponding number into text according to the specified number format.

Today, the system date display date is given.

VALUE converts a text string representing a numeric value into a numeric value. Text-digital conversion

VLOOKUP looks up the specified numerical value in the first column of the data table and returns the numerical conditional positioning of the specified column in the current row of the data table.

WEEKDAY gives the number of weeks corresponding to the specified date. Weekly calculation