Check box selection

I want to add branches based on a check box selection. I have attached a sample file. I have tried to use formulas but unsuccessfully?
Thank you in advance

I am hoping someone can solve this problem? Do I need VBA or is there a formula available in Excel?
Thank You.