Is there a way to create a formula where D9 is included/excluded from the formula based on the answer to the dropdown selection of D13 (Financing Repairs? Yes/No)?
I've spent hours creating this real estate investment worksheet and just discoved a significant mistake.
Cells H7 (Finance Amount) and H8 (Down Payment Amount) assume the investor is financing the cost of "Repairs/Improvements" (cell D9).
This is not always the case. Sometimes investors finance the property and pay cash for repairs.