# Suggestions for alternative to using "IF" and "AND" functions, I have exceeded 64 levels.

1. ## Suggestions for alternative to using "IF" and "AND" functions, I have exceeded 64 levels.

Hi, I was using
``Please Login or Register  to view this content.``
with some other formulas to open a pdf file within various folders based on year and month, =2015 is the year and =4 is the month.
I now have too many years, excel error says no more than 64 levels. I currently need to go up to 2021 March.

I am looking for suggestions for how I may be able to accomplish this please!
Many thanks

2. ## Re: Suggestions for alternative to using "IF" and "AND" functions, I have exceeded 64 lev

I'm sure there is a way to construct this string without the IF/AND, but you need to explain how you are getting the file names. How you get "2015-16" from April 2015, and why are April and May both "2015-16"?

P.S. Nice user name!

3. ## Re: Suggestions for alternative to using "IF" and "AND" functions, I have exceeded 64 lev

=IF(AND(H21=2015,I21=4),"2015-16",IF(AND(H21=2015,I21=5),"2015-16"))

What does the "16" in "2015-16" represent and should the second instance also be "2015-16" ??

4. ## Re: Suggestions for alternative to using "IF" and "AND" functions, I have exceeded 64 lev

Please see attached file, I hope it makes it a little clearer.

5. ## Re: Suggestions for alternative to using "IF" and "AND" functions, I have exceeded 64 lev

This formula will compose the folder name based on C5 and D5. It will work for any year.

Formula:
`Please Login or Register  to view this content.`

P.S. Future reference: It would have helped immensely to mention in your first post that 2015-16 means a fiscal year from April 2015 to March 2016.

6. ## Re: Suggestions for alternative to using "IF" and "AND" functions, I have exceeded 64 lev

6StringJazzer. Thank you very much for the code, perfect thanks. Apologies for the initial lack of detail.

7. ## Re: Suggestions for alternative to using "IF" and "AND" functions, I have exceeded 64 lev

Glad to help! And I will think of you every time I pick up a tuning fork.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1