Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

Nine Common Function Formulas in Microsoft Excel

Date:2020-10-9 Author:Sandra

Familiar with Excel function formulas can help us to complete work more quickly and efficiently when processing data. For ordinary people, they only need to master some commonly used formulas and complete daily office work. Today, the author will share with you a few simple and practical function formulas.

1. Rank Function

=RANK(F2,F:F)

This function formula can help you quickly calculate the ranking order in the region.

Nine Common Function Formulas in Microsoft Excel

2. Get the Maximum

=MAX(F2:F6)

You can quickly get the largest number in the area by this way.

Nine Common Function Formulas in Microsoft Excel

3. Get Minimum

=MIN(F2:F6)

You can quickly get the smallest value in the area.

Nine Common Function Formulas in Microsoft Excel

4. Round to Hundreds

=ROUND(A8,-2)

 “-2” means rounding to two digits.

Sometimes the value in the table is too large, and we hope to simplify the data and round it to hundreds.

Nine Common Function Formulas in Microsoft Excel

5.Rounding

=ROUND(D8,0)

This function formula refers to rounding and does not keep decimals.

Nine Common Function Formulas in Microsoft Excel

6. Absolute Value

=ABS(A17)

This function formula can take the absolute value, changing the negative number in the table into a positive number.

Nine Common Function Formulas in Microsoft Excel

7. Conditional Statistics Function

=COUNTIF(F2:F6,”>320″)

This function formula expresses how many scores are greater than 320 in the statistical area.

Nine Common Function Formulas in Microsoft Excel

8. Calculate Expiration Time

=EDATE(A30,B30)

If you need to count the signing time of the contract, the duration of the contract, and the expiration time of the contract, you can use this function formula. It can help you get results quickly.

Nine Common Function Formulas in Microsoft Excel

9. Generate Random Numbers

= RANDBETWEEN(1,100)

This function formula can randomly generate random integers in the specified range. (1,100) refers to randomly generating a random number ranging from 1 to 100.

Nine Common Function Formulas in Microsoft Excel
Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *