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 ...
djclements
Jan 05, 2024Silver Contributor
MarkAuger It should be =IFS(AND(A1=B1,C1=D1),"Green", more conditions...). Just remove the equal sign before AND.
MarkAuger
Jan 08, 2024Copper Contributor
djclements Thanks so much!
- djclementsJan 08, 2024Silver Contributor
MarkAuger You're very welcome! 🙂