How to use Excel table if formula superposition technique

Source: Internet
Author: User

1, the first step, you may all just know if the simple use of formula, but in fact the formula itself can be superimposed on the use of, first of all to see what I have done the results (such as figure), so that we understand that today we want to achieve what effect, to test the back of our past right.

2, the second step, open the form we need to do, then find the formula we need in all the options in the FX box and select it, as shown in the graph to see if it is a judgment formula, to determine whether a condition is met, to return a value if it satisfies, and to return another value if it is not satisfied, but it is not only a criterion.

3, the third step, first of all to review an If the use of a simple condition, if there are three parameters (such as the figure), the first parameter is the judged condition, which is the Memo column in the table, and we use the IF formula in the number of numbers to express whether the column of the memo is a gift, as shown in the figure to enter the conditions we need.

4, step fourth, if the second parameter and the third parameter refers to the value returned by the judgment condition, this value is set by ourselves, can be set according to need, of course, but also set to text, as shown in the A2 whether for the gift as a condition, give the return value is 0, the contrary is 1, The calculated B2 value of 1 is obviously right because A2 is a null value.

5, the fifth step, you may say that a pair can not represent the whole is right, when the arrow becomes + double click, fill in the entire column we need, we can see that is really correct, this is just a simple application, the review is here, we will go to the superposition of if use.

6, the sixth step, as shown in the number of days I want to sell the condition, let the value return to the Judge column, the same first in the FX all the options to find the formula we need if and then select it, and then enter the first parameter for the primary condition we need, the second parameter satisfies the first parameter should return the value, as shown in the figure.

7, the seventh step, if the superposition of the IF function is in its third parameter, the IF function can be embedded up to 7 layers, such as the number of sales days less than 3 The return value is 3D (the difference is 3 days),3=< sales days <7 The value returned is 7d,7=< sales days <7 The value returned is 7 D, And so on and so on, you may not understand why equal to 3 is in the 7D in fact, we think of 10-7=3, in fact, 7-10 have 2 integer value, but from 7 to 101 total has 4 values, so equal to 3 is in 7D.

8, the eighth step, we can see that we divided the interval is 0-3,4-7,8-15,16-30,31-60,61-90,90 above for the cumulative, when the arrow into + double-click, fill in the whole column we need, we can test our formula is correct, The superposition of if is used to replace lookup and some other formulas.

Attention matters

When the first condition is set, the minimum value must be set, and the setting of the condition is in the order of completion.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.