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!
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!
It would look something like:Formula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Or maybe something like this:
Formula:Please Login or Register to view this content.
Had another look at your workbook and this should be a generic solution to the problem:
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks