Introduction of Eight Most Commonly Used Functions in excel Spreadsheet

Everyone usually uses excel, word and other office software frequently in the office, and will encounter statistical data. Excel function allows users to directly use it to perform a series of operations on some numerical values. Today, Bian Xiao will share with you the eight most commonly used functions in OfficeExcel spreadsheet software and some other very convenient functions.

Details are as follows:

1.IF function

IF function is a very common judging function, which is equivalent to IF (judging conditions, results when conditions are met, results when conditions are not met). Take the following figure as an example. We want to judge whether it is more than 6 and less than 6, so the function we need to fill in is =IF(B2=6, "qualified" and "unqualified").

2. Conditional counting

Conditional counting is to count the number of qualified cells in an area. For example, if we think that the last few days are cloudy, we only need to enter =COUNTIF(B2:B 1 1, E3) to get that the last four days are cloudy. It is a very common and convenient function.

3. Merge cell contents

Sometimes we need to merge the contents in excel, but it takes a lot of time to operate one by one. In this case, you can use the function =A2B$ 1B2. We need to merge the date, weather and weather conditions here, so it is = consolidation range 1 consolidation range 2 consolidation range 3. Because the word weather is fixed, we will add one in the middle of B 1.

4. Extract the date of birth according to the ID number.

The function formula is =MID(B 1, 7,4) "Mid-year (B 1,1,2)" Mid-month (B 1,13,2) "

5. Rounding function

Rounding is also a function we often use, and the function value is =ROUND (numerical range, decimal places). For example, if we want to calculate E6/F6 and round it to one decimal place, then the function is =ROUND(E6/F6, 1).

6. Generate random numbers

The function formula for generating random numbers is =RANDBETWEEN (upper and lower numerical limits). For example, if we want to generate a random number of 0- 100, then the formula is =RANDBETWEEN(0, 100).

7. Average calculation

The function for calculating the average value is =AVERAGE (range of values).

8. Maximum and minimum functions

We can use MIN and MAX functions to find the minimum and maximum in pruning, and the function formulas are =MAIN () and =MAX ().

The above are several commonly used and practical function formulas in OFFICEEXCEL spreadsheet, hoping to help you work more smoothly. Thank you for watching this tutorial.