Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

Share 9 function formulas used every day in Excel: EDATE, RANK, RANDBETWEEN...

2024-04-25 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > IT Information >

Share

Shulou(Shulou.com)12/24 Report--

There are so many functions that we can't remember all of them, and we can't use many of them at all. Therefore, it is suggested that we only need to master some of the most commonly used function formulas to be able to cope with daily office work. Here, Mr. Wang will share with you some functions that are commonly used in daily work.

1. After calculating the expiration time of the contract with the formula, we can get the expiration time by setting the number format to "date".

The EDATE function calculates the expiration date on the same date as the issue date in mid-January.

= EDATE (A2 ~ B2)

2. Ranking calculation can calculate the ranking through the total score.

= RANK (E2meme)

3. Get the maximum value and return the maximum value in the area.

= MAX (E2:E8)

4. Get the minimum value in the return area.

= MIN (E2:E8)

5. Generate random number function RANDBETWEEN function can randomly generate random integers in a specified range.

= RANDBETWEEN (10 ~ 20) here is a random number in the range of 10 to 20 randomly generated.

6. if the number is too large, we want to simplify the data and round it to 100 digits.

= ROUND (A2Mae Murray 2)

7. How to convert a negative number into a positive number by taking an absolute value? We can use the absolute value function.

= ABS (A2)

8. Rounding does not retain decimals.

= ROUND (A2P0) = ROUND (numeric or numeric cell, number of digits to keep)

9. How many are there if the total score of conditional statistics is more than 250? You can modify it according to your own needs.

= COUNTIF (E2:E8, "> 250")

This article comes from the official account of Wechat: Word Technology Alliance (ID:Wordlm123), author: Wang Qi

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

IT Information

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report