Question: how do you make a yes formula in excel?
Answer: Select the list you will fill with the YES or NO drop down list, and click Data > Data Validation > Data Validation.
In the Data Validation dialog, under the Settings tab, please select List from the Allow drop down list, type Yes,No in the Source box, and click the OK button.