IFS(AND Question

[Dallas6570]

I am trying to use an IFS(AND formula without much success. It keeps telling me that I need another ")" and I am not sure why...

I explain in my example sheet what I am trying to do!
Any help would be appreciated!

[TMS]

It would look something like:

Please Login or Register  to view this content.

[Estevaoba]

Or maybe something like this:

Please Login or Register  to view this content.

[TMS]

Had another look at your workbook and this should be a generic solution to the problem:

Please Login or Register  to view this content.