Hot answers tagged

1

The OR is for boolean values (2 conditions) not for multiple possibilities for the = sign. This should work: =IF(AND([Expiration Date]<[TODAY]+180, OR([Current Status]="ACTIVE",[Current Status] = "EXPIRED")), "HIGH", IF(AND([Expiration Date]<[TODAY]+180, [Current Status]="RENEWED"), "NO ACTION REQUIRED", "NORMAL")) You were also missing several ...



Only top voted, non community-wiki answers of a minimum length are eligible