China Naming Network - Ziwei Dou Shu - 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.