excel2016 table IF formula overlay operation

Use IF formula to superimpose complex conditions to filter data in Excel 2016? PHP editor Baicao has the answer for you! When you need to filter data based on multiple conditions, the superimposed use of IF functions can provide a more flexible way. This article will delve into how to superimpose multiple IF functions in Excel 2016 to easily implement complex condition filtering and help you process data efficiently.

Maybe everyone only knows the simple application of the IF formula, but in fact, this formula itself can be used superimposed. First, let’s take a look at the results that have been done here (as shown in the picture), so that everyone will understand. , what effect will we use IF to achieve in the near future, so as to check whether our process is correct later.

Open the form that needs to be done, find the formula IF we need among all the options in fx and select it. As you can see in the figure, IF is a judgment formula to judge whether a certain If the condition is met, it returns a value, if it is not met, it returns another value, but it does not only judge one condition.

Let me first introduce you to the usage of a simple condition of IF. IF has three parameters (as shown in the picture). The first parameter is the condition to be judged, which is the remark column in the table. , and we use the IF formula to use numbers in the quantity column to express whether the remarks column is a gift, as shown in the figure to enter the conditions you need.

The second parameter and the third parameter of IF refer to the value returned after judging the condition. This value is set by ourselves and can be set as needed. Of course, However, if it is set to text, as shown in the figure, it is conditional on whether A2 is a gift. The value returned by the gift is 0, otherwise it is 1. The calculated value of B2 is 1, which is obviously correct, because A2 is a null value.

Maybe you will say that even one pair does not mean that all are right. When the arrow changes, double-click to fill in the entire column we need. You can see that it is indeed the case. Correct, this is just a simple application, the review ends here, now we will move to the superimposed use of IF.

As shown in the picture, we need to use the sales days column as a condition, and let the value return to the judgment column. Similarly, first find the formula IF we need among all the options at fx and select it. , and then enter the first parameter as the primary condition we need, and the second parameter satisfies the value that the first parameter should return, as shown in the figure.

The overlay of the IF function is in its third parameter. The IF function can be inlaid with up to 7 layers. As shown in the figure, the number of sales days is less than 3. The return value is 3D (3D means 3 days) ), 3=

You can see that the intervals we divide are 0-3, 4-7, 8-15, 16-30, 31-60, 61-90, and above 90 is cumulative. When the arrow changes to , double-click to fill in the entire column we need. You can check whether our formula is correct. The superposition of IF can replace LOOKUP and some other formulas.

The above is the detailed content of excel2016 table IF formula overlay operation. For more information, please follow other related articles on the PHP Chinese website!