Forum Discussion
MarkAuger
Jan 05, 2024Copper Contributor
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 ...
MarkAuger
Jan 08, 2024Copper Contributor
djclements Thanks so much!
djclements
Jan 08, 2024Bronze Contributor
MarkAuger You're very welcome! 🙂