Hello, I am trying to work out how to do a nested if and ISBLANK formula and display the text if it is not blank

So far I have this:

=If(Not(ISBLANK(SCB!A8)),”X”,If(Not(ISBLANK(Voda!A8),”Y”,If(Not(ISBLANK(Fixnetix!A8),”A”,If(Not(ISBLANK(IOW!A8),”B”,”No open cases)

It didn't work though and I am trying to pull data from 4 other workbooks that will constantly be changing.

My theory is:

-If X has data, then display but if X does not have data move to Y

-If Y has data, then display but if it does not have data move to A

-If A has data, then display but if it does not have data move to B

-If B has data, then display but if it does not have data, then display “No open cases”

These are the variables I have

• (SCB!A8)
• (Voda!A8)
• (Fixnetix!A8)
• (IOW!A8)
• "No open cases"

Thanks for your help!