May 03 2021 01:42 AM - edited May 03 2021 03:16 AM
Hello. I would like Excel to enter data from one cell into another cell, where the formula is written in 3rd cell. For example,
I have A1 as drop down list with two options (Male, Female).
In B1 I would like to set the value to "True" if "Male" is selected, otherwise I will enter the value manually in B1.
and If I select "Male" in A1 again it will set B1 as "True" automatically. Hence I would need to have the formula in C1. Is that possible?
The example is attached. I use Excel 2019, WIN 10.
May 03 2021 01:59 AM
May 03 2021 03:16 AM