Formatting text without millions of nested IF statements

I've got a cell, A1.

A1 is "(A/B/C/D)" exactly as I've shown, including brackets and "/"

Now I want this cell to show A if named range AY is TRUE (using a checkbox). Same for B: show it only if named range BY is TRUE. Same for C: show it only if named range CY is TRUE, and so on...

But note that the formatting quickly looks off and it's hard to get a "/" showing up appropriately without using multiple nested if statements which make enormous ugly formulas.

If only named range AY is TRUE I want A1 to be "(A)". If only BY is true, I want A1 to be (B). If BY and DY are true I want A1 to be "(B/D)".

See what I mean?

I can use this formula A1=if(AY, "(A)", if(BY, "(A/B)","(A)",.... and you see how this'll just get enormous accounting for all combinations.

Any options?

Hi there,
would something like this work?

=SUBSTITUTE("(" & if(AY,"A/","") & if(BY,"B/","") & if(CY,"C/","") & if(DY,"D/","") & ")","/)",")")

Hope this helps

Yes, that's exactly what I was looking for!