Forum Discussion
Excel
- Write a formula in cell G12 to determine (True/False) if at least one day in spring had above average temperature.
1 Reply
Hi
Change the formula in E2 to =D2<C2 and copy it down.
Formula in G12:
=COUNTIFS(A2:A9,"spring",E2:E9,TRUE)>0
