Custom Excel Conditional Formula

I’m looking for a concise, easy-to-maintain conditional formula that handles clear if-else scenarios in Excel. I’ll provide the worksheet, the specific cells involved, and the exact logic I need the formula to follow.

Deliverables
• A single, fully-tested formula (or nested formula) placed in the designated cell(s).
• A brief note explaining how the logic flows so I can tweak it later if my data changes.

The sheet is already structured, so you’ll only focus on crafting the formula and confirming it works with my sample data. If a quick adjustment is needed after the first draft, I’ll let you know right away.