Forum Discussion
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 me a formula error
When i put =AND(A1=B1,C1=D1) into Cell E1 and then change the formula in F1 to be
=IFS(E1,"Green", more conditions...) then Cell F1 evaluates perfectly
What am i doing wrong?
MarkAuger It should be =IFS(AND(A1=B1,C1=D1),"Green", more conditions...). Just remove the equal sign before AND.
djclements Thanks so much!
MarkAuger You're very welcome! 🙂
