Feb 15 2021 06:08 AM
Hi,
I want cell C1 to display either 1 or 0 based on the answer from a drop down menu in cell B1.
The choices in the drop down menu is either "Yes" or "No"
Example: Select "Yes" in the drop down menu in B1, and then automatically get "1" in cell C1.
Select "No" in the drop down menu in B1, and then automatically get "0" in cell C1.
Feb 15 2021 06:24 AM
Here is an example file with the result you specified.
Additional information from microsoft via drop-down lists
Create a drop-down list
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Feb 15 2021 07:22 AM