Excel returns one result if multiple conditions are met?

If there is no repetition after the plan + unit + keyword is connected, then you can use the array function, enter in j2 and then hold down the ctrl+shift key, and then press enter, the result is as follows:

Multi-conditions should not be extracted using the vlookup function, but rather with the lookup function.

The formula should be used:=lookup(1,0/((a:a=f2)*(b:

b=g2)*(c:c=h2)),d:d)

Or use the regional formula:

lookup(1,0/(($a$2:$a$440=f2)*(b$2:$b$440=g2)*(c$2:$c$440=h2)),d$2:$d$440)

Regional formulas will be smoother).

Copy and pull down to ......

Since it is to meet the conditions. How not to use the if function.

In Excel, if you want to return a certain value if you meet multiple conditions, and if you don't meet another value, the specific method and operation steps are as follows.

For example, if the condition value is 6 and the condition value is 8, the specific steps are as follows:

1. Find the Excel** document that needs to be operated on the computer, as shown in the figure below, and enter the next step.

2. For example, enter the data to be judged in column B, as shown in the figure below, and then enter the next step.

3. In the cell that needs to return the value, enter the state, and then enter the formula =if(or((b4>=3000)*(b4<=3500),(b4>=4000)*(b4<=5000),(b4>=5900)*(b4<=6300)),6,8), as shown in the following figure, to enter the next step.

4. After entering the if formula, you can see that the return value has been automatically entered into the cell position, as shown in the figure below, and enter the next step.

5. Then pull down the judgment result cell, you can get the judgment result value of several other numbers, as shown in the figure below, to complete all operations.

<> array formula, press Ctrl+Shift+Enter to confirm.

e3 input = v lookup (b$1 and a$3, if (, Table 2!) A: And Table 2! b:b, table:c), hold down the Ctrl key and hold down the shift key.

The implementation method and detailed operation steps are as follows:

1. In the first step, open the ** to be processed, fill in the score and grade, as shown in the figure below, and then enter the next step.

2. Secondly, after finishing the above steps, in cell B2, enter the formula pointed to by the following arrows as below screenshot shown, and then go to the next step.

3. Then, after completing the above steps, press the Enter key to get the result, as shown in the figure below, and then proceed to the next step.

4. Finally, after completing the above steps, you will get the desired result, as shown in the figure below. In this way, the problem is solved.

In Excel 2007, you can satisfy the caption requirements with the following formula:

=if(and(a2=0,b2=0,c2>0,d2=0),"Production closed",if(and(a2=0,b2>0,c2>0,d2>0),"There is a shortage of documents to apply",if(and(a2=0,b2>0,c2=0,d2>0),"Batch accounts are not generated",if(and(a2>0,b2=0,c2>0,d2>0),"There is a deficit in the issuance of permits",if(and(a2>0,b2>0,c2=0,d2>0),"There is a shortfall in the batch accounts",if(and(a2>0,b2=0,c2=0,d2>0),"Ready for feeding",if(and(a2>0,b2=0,c2>0,d2=0),"Repeat feeding","

The result of the formula is shown in the following figure:

Diagram of the results of the disclosure.

Enter or copy and paste the following formula in e2.

lookup(concat(n(a2:d2>0)), pull-down padding.

Enter the following formula in cell H2 and fill the formula down.

2007 or later.

sumifs(c:c,a:a,f2,b:b,g2) 2003 or later.

sumproduct((a$2:a$10=f2)*(b$2:b$10=g2)*c$2:c$10)

See attached drawings for details.

1. Open the ** that needs to be processed: you need to fill in the score level.

2. Enter the following formula in cell B2 before the bridge "hail elimination = if(a2<60,"Fail",if(a2<70,"Pass",if(a2<80,"Medium",if(a2<90,"Good",if(a2<=100,"Excellent"))

3. Press enter to get the result.

1. Open the ** that needs to be processed: you need to fill in the score level.

2. Enter the following formula "=if(a2<60," in cell B2"Fail",if(a2<70,"Pass",if(a2<80,"Medium",if(a2<90,"Good",if(a2<=100,"Excellent")))

3. Press enter to get the result.

1. First of all, open Excel** in the computer, and select the data range that needs to be sorted, as shown in the figure below.

2. Then click "Sort & Filter - Custom Sorting" as shown in the image below.

3. After setting the first sorting condition, click "Add Condition".

4. After setting the second sorting condition, click "OK" to meet the two equal conditions.

Enter or copy and paste the following formulas in C1 in Table 1.

lookup(1,0 ((Table 2!.)b:b=a1)*(Table 2!.)c:c=b1)), Table 2!a:a)

Pull-down padding.

<> enter or copy-paste one of the following formulas in e2.

iferror(vlookup(concat(a2:d2),g:h,2,),iferror(vlookup(concat(a2:d2),,2,),drop-down padding.

You can use vlookup, for example:

I didn't write all the second arguments of vlookup(a1&b1&c1&d1,2,0), but you should know how to add them, pay attention to commas, semicolons, example:

According to the logical relationship on the figure, if column A is not a "no", I don't understand what it shows! Just a few logical relationships listed on the diagram can be entered in cell E2:

=if(a1="Nope",if(c1="Yes",if((b1="Yes")*d1="Nope"), value-added recommendations","Design flaws"),if(d1="Yes","Operational defects",if(b1="Yes","Invalid result, please select again","Invalid result, please fill in the form again"Unknown")

Copy and pull down to ......

The table hair comes out, the judgment is sent out according to the conditions, and then the words written are easy to write, the key is that it is not easy to write without judgment conditions.

1. First use the and function.

to indicate that multiple conditions are met at the same time.

2. If the text of column A is "A", and the data of column B is greater than 210, mark "Y" in column C, and enter the formula =if(and(a2="a",B2>210),"Y"," in C2

3. Each condition and criterion is judged to be equal, if it is equal to return true, otherwise the rollover returns false, only all conditions and judgments are patiently returned to true, that is, when all conditions are met, the and function will return true.

4. Then use the OR function.

To illustrate, as long as one or more of the multiple conditions are met.

5. If the text of column A is "A", or the data of column B is greater than 150, mark "Y" in column C.