Traditional Culture Encyclopedia - Weather inquiry - 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,))