Excel Tutorial: Forget That IF Function

Tanabata romantic date "Hui"

Super Member Lifetime Card 23% off for a limited time

The original price is 168. Sign up today for only 129!

Don't miss it. ヾ(◍°∇°◍)ﾉﾞ

The IF function is the most popular function in EXCEL. It can solve the problem of conditional judgment with three simple parameters. It is easy for experts to use, and comfortable for rookies. It is precisely because of his closeness to the people that everyone is becoming more and more lazy. When encountering a small problem, he has to trouble the IF function. In fact, there is no need to use a knife to kill a chicken?

Let me give you a brief introduction to IF, the IF function is to determine whether a certain condition is met, if it is satisfied, it returns a value, if not, it returns another value.

The function expression is IF(logical_test,value_if_true,value_if_false)

The logical_test is any value or expression whose calculation result may be TRUE or FALSE, the value to be returned when the value_if_true parameter 1 is calculated as TRUE, and the value to be returned when the value_if_false parameter 1 is calculated as FALSE.

Example 1: Simple logical judgment

For simple logical judgments, the IF function can indeed be used. The following table shows the results obtained by using the IF function.

In fact, for this, we can directly use logical operators to judge, see the following table.

This can also reduce the operation process of EXCEL. After all, each additional operation process will slow down the running speed of EXCEL.

Example 2: Select the maximum and minimum values

When you choose the maximum value and minimum value, don't bother the old man with the IF function, after all, the IF function is not easy for others. Let's take a look at the comparison.

For the most value problem, it is most convenient and concise to use the MAX and MIN functions, and the more the value, the more obvious the difference. After all, MAX and MIN only need to check the box to select the maximum or minimum value.

Example 3: Select the Kth largest/smallest value

When the little cuties need to select the Kth largest/smallest value, if the IF function is used, the IF function needs to be nested, and for the cuties who are not so proficient in using EXCEL, such an operation may also lead to manual Shaking, editing the wrong formula, thankless. It's not that I deliberately exaggerate, let's take a look at the formula of the last wave of IF functions =IF(B2>C2,IF(B2>D2,IF(C2>D2,C2,D2),B2),IF(B2>D2, B2,IF(C2>D2,D2,C2))) , I feel a little dizzy when I look at it. In contrast, the LARGE function looks more friendly, after all, the formula has only two parameters.

In general, it's these two things:

1. When judging conditions, it is best to choose logical judgments to judge

2. When selecting values, the MAX/MIN/LARGE/SMALL functions are more concise.

However, this does not mean that the IF function is useless. In the next issue, I will give you a detailed introduction to the many advantages of IF. Remember to come and learn!

That's all for today's sharing. If the tutorial is useful to you, I hope you will share and support the editor! Every like and repost of yours is the motivation to support the editor to insist on originality.

Why choose us, the platform advantage is there

Advantage ①: VIP can learn all tutorials, unlimited learning + supporting material source files + unlimited downloads

Advantage 2: Support WeChat public account + applet + APP + PC website for multi-platform learning

Advantage 3: Support offline viewing, double-speed viewing, allowing you to learn anytime, anywhere

Advantage ④: VIP logo, distinguished status + independent after-sales group answers

★ FAQ ★

①Xiao Ai: Can you watch all the courses after buying VIP ?

Well, yes, including future updates (thanks for your support, we will insist on high-quality teaching updates)

②Xiao Ai: Hello, how do you study ?

Pay attention to the Aizhiqu Education Service Account, you can directly enter the official website to learn from the menu navigation, or you can enter the applet and download the APP!

Computer login to https://www.92zhiqu.com

(Mobile phone, computer learning is essential)

③Xiao Ai: what to do if you do n’t understand

Provide after-sales answers, pay to contact customer service and join the group (pay to contact WeChat customer service, just take a screenshot)

④Xiao Ai: Provide video courseware materials ?

Well, original high-definition video, these are provided (original tutorial, these are the most basic requirements)

⑤Classmate Xiao Ai: Validity period of study ?

Annual membership and lifetime membership, unlimited lifetime membership (self-built website + original tutorial + Aichiqu brand guarantee)

⑥ Primary school students: Does the website support accelerated viewing ?

kindness. At present, mobile phone applet + APP + computer PC all support 1.5 times accelerated viewing or slow playback

⑦ Does the course support offline download ?

kindness. Both Android and Apple IOS APP support mobile phone offline download

Computer downloads are provided by contacting WeChat customer service 18074746783.

⑧ How about the quality of the course ?

Aizhiqu Education high-quality video as the starting point, high-definition subtitles, support for audition

If there is anything else you need to consult, please contact WeChat customer service 18074746783

Long press to identify the QR code "Add Customer Service"

Click to read the original text , log in to the official website with one click, and learn from a large number of video VIPs! (you can try it out)