Using =AND with an IFS

[MarkAuger]

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?

[#2]

@MarkAuger It should be =IFS(AND(A1=B1,C1=D1),"Green", more conditions...). Just remove the equal sign before AND.

[#3]

@djclements Thanks so much!

[#4]

@MarkAuger You're very welcome! 🙂