Forum Discussion
Seth Krukowski
Oct 16, 2018Copper Contributor
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 ...
Lorenzo Kim
Oct 16, 2018Bronze Contributor
try:
in cell F4 =IF(M5="M","MALE","FEMALE")
in cell F4 =IF(M5="M","MALE","FEMALE")