What are the commonly used functions in Excel tables? List of commonly used functions in Excel

Excel is an office software that we often use. We use it to organize various data. We can calculate it through function formulas, but many users don’t know what are the commonly used functions in Excel tables? In response to this problem, today the editor of PHP Chinese website will share with you the common functions and usage methods of Excel. Interested friends can come and learn about it.

Comprehensive list of commonly used functions in Excel:

Question: When using Excel, do you need to quickly calculate the sum of data? Simple explanation: PHP editor Shinichi recommends using the SUM function, which can add numbers within a specified range and help you easily obtain the sum. Guidance: Read on to learn how the SUM function is used and how to apply it in your Excel worksheet.

For example: Counting a cell range: =sum(A1:A10) Counting multiple cell ranges: =sum(A1:A10, C1:C10)

2. AVERAGE function: The function of Average is to calculate average. The function formula is =AVERAGE( )

For example: Calculate the average of multiple cells =AVERAGE(A1:A12)

3. Count function: Its function is to calculate the number of cells. The function formula is =COUNT( )

For example =COUNT(A1:A12)

4. IF function: The function of the IF function is to judge a condition and then return the specified value based on the result of the judgment.

IF function formula is: =IF (logical judgment, the result when it is TRUE, the result when it is FALSE)

For example: the given condition is A1》A5, if the comparison result is TRUE, then the IF function returns the first The value of the two parameters; if FALSE, returns the value of the third parameter. =IF(A1》A5,1,2)

5. NOW function and TODAY function: NOW function returns date and time. The TODAY function only returns the date.

Both the NOW function and the TODAY function have no parameters, just a pair of brackets: =NOW()=TODAY()

Suppose you want to calculate how many days a project has been in progress until today? =TODAY()-Start date, the resulting number is the number of days the project will be carried out.

6. VLOOKUP function: The VLOOKUP function is used to find data in the table.

The syntax formula of the function is: =VLOOKUP (lookup value, area, which column to return, 1 approximate match 0 exact match)

The above is the detailed content of What are the commonly used functions in Excel tables? List of commonly used functions in Excel. For more information, please follow other related articles on the PHP Chinese website!