Repair Excel IF Formula Logic

My current workbook relies on several IF-based formulas but the results are clearly wrong, throwing off every downstream total. I can see that the logic in those conditional calculations is the culprit, yet I’m not sure whether the tests should revolve around text, numbers, dates—or a mix of all three.

Here’s what I need from you: dive into the file, diagnose why the existing IF statements misfire, decide what the correct conditions ought to be, and rebuild the formulas so the calculations finally make sense. Once the logic is solid, every related total, percentage, or summary cell should update accurately without manual intervention.

Please return the corrected spreadsheet and a brief, plain-English note summarising the adjustments you made and any edge cases I should watch for. I’m working exclusively in standard Microsoft Excel, so no add-ins or external scripts are required—just clean, dependable formula work inside the file itself.