Traditional Culture Encyclopedia - Weather forecast - Excel function formula satisfying two conditions at the same time
Excel function formula satisfying two conditions at the same time
If the function can be used to solve the problem
Suppose the navigation instrument is in unit B2 and the weather "the first day" is in unit B8.
In cell D8 (the first day of food consumption), enter:
=IF(B8= "storm "，IF(B$2= 1， 1，3)，)
Enter, and then drop down to copy.
- Previous article:How many counties and cities are there in Jining?
- Next article:What are the hazards of continuous rain?
- Related articles
- Messages from relatives on Qingming Festival
- How to raise succulents in summer
- Sumawan Autumn Tour Composition 400 Words
- Why does Mount Fuji in Japan snow all the year round?
- Pukou poetry
- Can underwear with variable temperature bottom be worn?
- Weather in Taishan District, Tai 'an City, Shandong Province
- Yunnan Torch Festival cancelled
- How to divide the color of early warning level?
- What's changed when summer comes?