How to display the contents of the third cell after the conditions are met in the first two cells in

Combine the if and and functions.

to deal with it.

Excel version reference: 2010

The test satisfies the conditions of A1=1 and B1=2, and the contents of C1 are displayed in D1, otherwise they are displayed as empty.

1. Select cell D1.

2. Enter the formula: =if(and(a1=1,b1=2),c1,""3. Press Enter to see the effect.

Enter "Please enter the name of the sales unit" in Sheet3 A1, enter "Please enter the product name" in B1, and enter "Unit price is" in C1

Enter =if(a2=) in sheet3 c2"",vlookup(b2,sheet2!a:b,2,false),if(b2="","Please enter a product name",vlookup(a2,sheet1!

a:c,3,false)))

Can you be more auspicious? Do you have only one column in Table 3 or do you have 3 columns, do you enter the name of the sales unit and the name of the product in one column to convert it to the unit price, or do you enter the name of the sales unit and the name of the product in the first and second columns to generate the unit in the three columns?

Table 1 you have given, assuming that the product name and unit price in Table 2 are in the two columns of AB, and Table 3 is in the three columns of ABC.

The labels (the lowest name) of the three tables are also separate tables.

1. Table. Table III.

Enter =if(a2=) in cell C2 in Table 3"", vlookup(b2, table 2!) a:b,2),vlookup(b2,table 1!) c:d,2))

The meaning of the function is that if the unit name is empty, the unit price is taken from Table 2, otherwise, the unit price is taken from Table 1. Same as you mean.

Not detailed, not understood, for example.

According to your requirements, it can be done, and the effect is as follows.

Enter the formula in d1.

if(b2<=35,if(c2>=90,"Excellent",if(c2>=70,"Pass","Fail")),if(c2>=80,"Excellent",if(c2>=60,"Pass","Fail")))

The above cells need to be changed to your own cells.

If it doesn't work, you can continue to communicate privately.

Please raise your precious little hand and give it a thumbs up, hehe!

=if(and(a1<=35,a2>=90),"Excellent",if(and(a1<=35,a2>=70),"Pass",if(and(a1>35,a2>=80),"Excellent",if(and(a1>35,a2>=60),"Pass","Fail")))

FYI

You can remove unwanted conditional formatting from an admin rule by doing the following:

1. As shown below, there are two conditional formatting in cell A1, then click the cell and click the Start menu.

2. Then click "Conditional Formatting" under the start menu, and click "Manage Rules" in the drop-down menu.

3. At this time, you can view the conditional formatting in cell A1, click to select the unwanted conditional formatting, and click "Delete Rule" above.

4. As shown in the figure below, you can delete unwanted conditional formatting after using the above steps.

Array formulas, that's what you mean. (I use 2:26 for the area, you adjust the interval yourself).

If you don't understand, take the question as the content (the subject of the email must contain "excel", and I will use this as a basis to identify non-spam emails to avoid accidental deletion), and the excel sample file (try to detail the current situation and target effect) as an attachment to help you see.

**It doesn't seem to be the same thing as the title, I try to understand: when there is a and B in the data source: A is in front, extract A, B is in front, extract B. There is only A, only B, or none of the two in the data source, and "None" is displayed.

B2 formula = iferror(mid(a2,min(find(.)"a",a2),find("b",a2)),1),"None")。Pull-down padding.

What you ultimately want, what you mean is not clear enough.

"When the value in 3 cells reaches the condition, it will be displayed in one of the cells", what is displayed? Generally, it can only be displayed in one of the cells. In this case, the "conditional formatting" function is generally used.

Please refer to the attached operating instructions.