The new function IFS is here, and multiple IF nesters are completely abandoned by Microsoft!Hurry up and learn

Today is Excel is the third part of the common function collection. Let's learn how to use the IFS function 逇. The ifs function can be said to be born for the [interval judgment]. Let's learn this function!

1. The role and parameters of IFS function

IFS: The judgment condition is correct. If the condition is correct, the corresponding result is returned.

Grammar: = ifs (logical_test1, value_if_true1, [logical_test2, value_if_true2], ...)

The first parameter: the first condition and the second parameter: the result returned when the first condition is correct: the second condition the fourth parameter: the result of the second condition is correct The corresponding conditions and results of the group

Compared with the IF function, the IFS function returns the result when there is no conditional error. If the condition is not met, it will return the error value of#n/A Look at his usage how to use

2. Division judgment

The appearance of ifs function is to solve the problem of [interval judgment]. In other cases, please use the IF function to judge condition directly, so for ifs functions, we only master [interval judgment].

Still the previous example, as shown in the figure below, we want to calculate the [Level] based on [Assessment and Score]

= Ifs (b6> = 85, "Excellent", B6> = 75, "Good", B6> = 60, "Du", B6 <60, "Failure"))

First parameter: B6> = 85 Two parameters: "Excellent" third parameter: B6> = 75 Fourth parameter: "Good" Fifth Parameter: B6> = 60 Sixth Parameter: "and Ge" Seventh Parameter: B6 <60 Eighth Parameter: Although there are many parameters of "failure", it is very easy to understand. We have 4 areas where there are 4 judgments. Each parameter is a set of conditions. These 4 areas correspond to 4 sets of conditions. The logic is clear, which is more convenient to read than the nested formula of the IF function.

The operation order of the function is calculated from left to right in the order of the conditions in the formula, which is consistent with the nesting of the IF function. If you don’t understand, you can turn it over the method of using the IF function in the previous section.

The above is all the content shared today, how about? Have you learned it?

I am Excel from zero to one, follow me, and continue to share more Excel skills

Learn Excel from zero, improve efficiency and do not work overtime

Here ↓↓

- END -