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 FEMALE.

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..

     

  • BobOrrell's avatar
    BobOrrell
    Iron Contributor
    Oct 16, 2018

    Your intent is a little unclear.  If you are using that formula in Column F or Column M, you are probably getting some sort of circular reference error.  If you are using it in some other column, then the cell will display the word MALE if the values of cell F4 and M5 are the same, otherwise, it will display the word FEMALE.  If you want one cell to read MALE or FEMALE based on another cell having the letter M or F (really, anything other than M), then Mr. Kim's formula will work, just keep in mind that whatever cell you paste it in, cell M5 is the cell it's looking for the letter M.  If you are trying to get it to change based off the first letter you start to type, the Data Validation List suggestion will probably work for you.  

Resources