I need a function/formula to operate subject to a "yes" or "no" condition. That is, I want to use a conditional function in excel to enable me automatically operate a formula but subject to a "Yes" or "No" Condition. That is, I only want the formula to operate if the "Yes" Condition is selected from a drop down list in a defined cell and not operate if a "No" Condition is selected in that same cell from that same drop down list.

Can anyone assist with the relevant function/ formula? Thank-you