Update excel cell based on another cell value, with having the formula in 3rd cell

%3CLINGO-SUB%20id%3D%22lingo-sub-2316484%22%20slang%3D%22en-US%22%3EUpdate%20excel%20cell%20based%20on%20another%20cell%20value%2C%20with%20having%20the%20formula%20in%203rd%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2316484%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHello.%26nbsp%3B%20I%20would%20like%20Excel%20to%20enter%20data%20from%20one%20cell%20into%20another%20cell%2C%20where%20the%20formula%26nbsp%3Bis%20written%20in%203rd%20cell.%26nbsp%3B%20For%20example%2C%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20have%20A1%20as%20drop%20down%20list%20with%20two%20options%20(Male%2C%20Female).%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EIn%20B1%20I%20would%20like%20to%20set%20the%20value%20to%20%22True%22%20if%20%22Male%22%20is%20selected%2C%20otherwise%20I%20will%20enter%20the%20value%20manually%20in%20B1.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3Eand%20If%20I%20select%20%22Male%22%20in%20A1%20again%20it%20will%20set%20B1%20as%20%22True%22%20automatically.%20Hence%20I%20would%20need%20to%20have%20the%20formula%20in%20C1.%20Is%20that%20possible%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2316484%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2316590%22%20slang%3D%22en-US%22%3ERe%3A%20Update%20excel%20cell%20based%20on%20another%20cell%20value%2C%20with%20having%20the%20formula%20in%203rd%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2316590%22%20slang%3D%22en-US%22%3EAnything%20is%20possible%20in%20this%20world%2C%20even%20at%20Toyota.%3CBR%20%2F%3EInsert%20a%20file%20with%20an%20example%20(without%20sensitive%20data)%20and%20use%20this%20file%20to%20explain%20your%20plan.%20Why%20does%20someone%20who%20wants%20to%20help%20even%20have%20to%20prepare%20the%20file%3F%3CBR%20%2F%3EAt%20the%20same%20time%20knowing%20the%20Excel%20version%20and%20sometimes%20the%20operating%20system%20is%20an%20advantage.%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20for%20your%20patience%20and%20understanding%3CBR%20%2F%3E%3CBR%20%2F%3ENikolino%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2316771%22%20slang%3D%22en-US%22%3ERe%3A%20Update%20excel%20cell%20based%20on%20another%20cell%20value%2C%20with%20having%20the%20formula%20in%203rd%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2316771%22%20slang%3D%22en-US%22%3EI%20have%20updated%20the%20post.%20Thanks%2C%3C%2FLINGO-BODY%3E
New Contributor

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.

2 Replies
Anything is possible in this world, even at Toyota.
Insert a file with an example (without sensitive data) and use this file to explain your plan. Why does someone who wants to help even have to prepare the file?
At the same time knowing the Excel version and sometimes the operating system is an advantage.

Thank you for your patience and understanding

Nikolino