Forum Discussion

MarkAuger's avatar
MarkAuger
Copper Contributor
Jan 05, 2024

Using =AND with an IFS

I am trying to use the IFS using =AND as the conditional,   e.g.in Cell F1 i enter the following =IFS(=AND(A1=B1,C1=D1),"Green", more conditions...),it does not evaluate the conditional i.e. gives ...

Resources