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.


1 Answer 1


Replace the references to D9 in H7 & H8 with if(D13="Yes","D9,0). This means that if D13 hasn't been marked as 'Yes' then D9 isn't added to the values in H7 or H8.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.