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

The title of the original text: "several function formulas are used every day, and daily office work is enough!" "

These days, do not know a few function formulas, do not dare to say that they understand Excel. In fact, ordinary people do not need to master too many functions, as long as they are proficient in a few of the most commonly used functions, they can cope with daily work.

VLOOKUP function description: the function of the VLOOKUP function is to give keywords and find the contents of the specified column.

Formula explanation: VLOOKUP (the value to look for, the area to look for, the column in which the data is returned in the search area, the exact match is "0" or the approximate match "1")

= VLOOKUP (D5, A2, B11, 2, 0)

IF function description: the IF function can judge "true" and "false" according to the specified conditions, and return the corresponding content through true or false.

Formula explanation: IF (test condition, result 1, result 2), display "result 1" if the "test condition" is met, and "result 2" if it is not satisfied.

= IF (A2=B2, "same", "different")

SUMIF function description: conditional summation of the specified area.

Formula interpretation: SUMIF (conditional region, summation condition, region that needs summation)

= SUMIF) here I ask for pens, pencils and erasers. What is the total sales?

SUMIFS function description: summation of multiple conditions.

Formula interpretation: SUMIFS (summation region, condition region 1, condition 1, condition region 2, condition 2)

The above one is about the sum of single conditions, so how to SUMIFS if there are many conditions? The first condition is by month, and the second condition is by product name, which must meet the sum of these two conditions.

The MID function states that the MID function is a function for intercepting strings.

Formula interpretation: MID (string, start position, number of strings)

= MID (B2p7p8) starts with the seventh character in the B2 cell string and returns eight characters.

DATEDIF function description: through the "start date" and "end date", get the number of days difference, month difference, year difference.

Formula explanation: DATEDIF (start date, end date, statistical method), the day difference is d; the month difference is m; the year difference is y.

= DATEDIF (A2 ~ B2, "d")

RANK function description: specify a numerical value for ranking.

Formula explanation: RANK (number, citation region, sort mode) sorting method is divided into "0" is descending order, "1" is ascending order, if not filled in, it is "descending order" by default.

= RANK (E2thecontrolling E2VO2VOULING 12)

IFERROR function description: the iferror function can solve the formula error value.

Formula interpretation: IFERROR (your formula, "return result")

= IFERROR ((B2-C2) / C2, "") We put the original formula into it, and the result is empty "".

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

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.