China Naming Network - Ziwei Dou Shu - Excelif function If a 1 is 3, a5 means "What a nice day today".
Excelif function If a 1 is 3, a5 means "What a nice day today".
If only one condition is judged, the formula is:
=IF(A 1=3, "Nice weather", "")
""in the formula stands for blank, that is, when A 1 is not 3, the formula returns blank. If you need to change it to something else, you can add double quotes. If it is changed to bad weather, the formula is:
=IF(A 1=3, "The weather is good today", "The weather is bad")
If there are many judgment conditions, it is suggested to find two free columns first. In this case, column F and column G are selected, and the corresponding conditional relations are established in advance.
B 1 formula drop-down list:
=IF(A 1= ""," ",VLOOKUP(A 1,F:G,2,))