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,))
- Previous article:Introduction of Tianshan tourist attractions
- Next article:Zola, Battle of Widdel.
- Related articles
- Can red sun bulbs be planted directly in root water?
- Brief introduction of the item
- Introduction of Wuzhishan Tourist Attractions in Shahe, Henan Province
- Long-distance love, good night, short love words
- Does Quzhou County belong to Handan City?
- What are the three major pains in life?
- How to write the learning experience of public bicycle dispatching management forest?
- When is the best time to travel to Gansu? What season is the best for Gansu tourism?
- A Collection of Off-season Tourism Promotions in Different Regions
- What are the top ten famous songs in China?