Hi guys,
I have a long nested if statement as follows:
IF(D4="3c","3a",IF(D4="3b","4c",IF(D4="3a","4b",IF(D4="4c","4a",IF(D4="4b","5c",IF(D4="4a","5b",IF(D4="5c","5a",IF(D4="5b","6c",IF(D4="5a","6b",IF(D4="6c","6a",IF(D4="6b","7c",IF(D4="6a","7b","False"))))))))))))

The above displays the text based on the inputted text in D4 (for arguments sake). However, I have two more long nested if statements like the above. They are as follows:

Nested IF statement 2: =IF(D4="3c","4c",IF(D4="3b","4b",IF(D4="3a","4a",IF(D4="4c","5c",IF(D4="4b","5b",IF(D4="4a","5a",IF(D4="5c","6c",IF(D4="5b","6b",IF(D4="5a","6a",IF(D4="6c","7c",IF(D4="6b","7b",IF(D4="6a","7a","False"))))))))))))

Nested IF statement 3:
=IF(D5="3c","4b",IF(D5="3b","4a",IF(D5="3a","5c",IF(D5="4c","5b",IF(D5="4b","5a",IF(D5="4a","6c",IF(D5="5c","6b",IF(D5="5b","6a",IF(D5="5a","7c",IF(D5="6c","7b",IF(D5="6b","7a",IF(D5="6a","8c","False"))))))))))))

Individually they work fine. However, I have another column in which users input either 3, 4 or 5. Now I want the correct nested if statement to execute based on which value (3,4 or 5) is entered. Lets call this cell A5

So this is how I want it to execute: If A5 = 3 then nested IF statement 1, If A5 = 4 then nested IF statement 2 and so forth.
Is this possible? Or am I doing it all wrong?