Skip to content

Latest commit

 

History

History
2 lines (2 loc) · 166 Bytes

excel.md

File metadata and controls

2 lines (2 loc) · 166 Bytes
Raw

Nested If

  • For example, to assess cell A2, we can write IF(A2<30,"Low",IF(AND(A2>30,A2<70),"Average",IF(AND(A2>70,A2<120),"High",IF(AND(A2>120),"Extreme",))))