B2B Healthcare Lead Generation VA -- 2

I keep a growing worksheet that tracks multiple projects, and my current logic relies on long, nested IF statements. The formulas have become hard to maintain and occasionally return incorrect results. I need a quick but precise overhaul:

• Audit the existing nested IF formulas and pinpoint why certain outputs are wrong.
• Restructure the logic—whether that means cleaner IF/IFS statements, a lookup-based approach, or another elegant solution—so it remains accurate and easy to edit later.
• Deliver the updated workbook plus a brief, in-sheet note explaining the new logic.

No dashboards or macros are necessary right now; I simply want dependable, streamlined formulas that work with standard Excel (Microsoft 365 / Excel 2019). If you are comfortable dissecting complex formulas and enjoy making them bullet-proof, I look forward to your help.