Forum Discussion

Seth Krukowski's avatar
Seth Krukowski
Copper Contributor
Oct 16, 2018

DATA VALIDATION FORMULA

I AM USING THE FORMULA =IF(F4=M5,"MALE","FEMALE") WHERE F COLUMN IS GENDER, M5=M BUT THE FORMULA DOES NOT WORK. IM TRYING TO MAKE IT SO WHEN I INPUT M IT GIVES ME MALE AND WHEN I INPUT F IT GIVES ME ...
excel
Formulas and Functions
Lorenzo Kim's avatar
Lorenzo Kim
Bronze Contributor
Oct 16, 2018

place the Data Validation on the cell that you prefer - then type on the source Male, Female

you can now have a selection.

pls see attached image.

hope you can make something out of it.

thanks..

 

Resources