Home

DATA VALIDATION FORMULA

%3CLINGO-SUB%20id%3D%22lingo-sub-271816%22%20slang%3D%22en-US%22%3EDATA%20VALIDATION%20FORMULA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-271816%22%20slang%3D%22en-US%22%3E%3CP%3EI%20AM%20USING%20THE%20FORMULA%26nbsp%3B%3DIF(F4%3DM5%2C%22MALE%22%2C%22FEMALE%22)%20WHERE%20F%20COLUMN%20IS%20GENDER%2C%20M5%3DM%20BUT%20THE%20FORMULA%20DOES%20NOT%20WORK.%20IM%20TRYING%20TO%20MAKE%20IT%20SO%20WHEN%20I%20INPUT%20M%20IT%20GIVES%20ME%20MALE%20AND%20WHEN%20I%20INPUT%20F%20IT%20GIVES%20ME%20FEMALE.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-271816%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-272101%22%20slang%3D%22en-US%22%3ERe%3A%20DATA%20VALIDATION%20FORMULA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-272101%22%20slang%3D%22en-US%22%3E%3CP%3EYour%20intent%20is%20a%20little%20unclear.%26nbsp%3B%20If%20you%20are%20using%20that%20formula%20in%20Column%20F%20or%20Column%20M%2C%20you%20are%20probably%20getting%20some%20sort%20of%20circular%20reference%20error.%26nbsp%3B%20If%20you%20are%20using%20it%20in%20some%20other%20column%2C%20then%20the%20cell%20will%20display%20the%20word%20MALE%20if%20the%20values%20of%20cell%20F4%20and%20M5%20are%20the%20same%2C%20otherwise%2C%20it%20will%20display%20the%20word%20FEMALE.%26nbsp%3B%20If%20you%20want%20one%20cell%20to%20read%20MALE%20or%20FEMALE%20based%20on%20another%20cell%20having%20the%20letter%20M%20or%20F%20(really%2C%20anything%20other%20than%20M)%2C%20then%20Mr.%20Kim's%20formula%20will%20work%2C%20just%20keep%20in%20mind%20that%20whatever%20cell%20you%20paste%20it%20in%2C%20cell%20M5%20is%20the%20cell%20it's%20looking%20for%20the%20letter%20M.%26nbsp%3B%20If%20you%20are%20trying%20to%20get%20it%20to%20change%20based%20off%20the%20first%20letter%20you%20start%20to%20type%2C%20the%20Data%20Validation%20List%20suggestion%20will%20probably%20work%20for%20you.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-271846%22%20slang%3D%22en-US%22%3ERe%3A%20DATA%20VALIDATION%20FORMULA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-271846%22%20slang%3D%22en-US%22%3Etry%3A%3CBR%20%2F%3Ein%20cell%20F4%20%3DIF(M5%3D%22M%22%2C%22MALE%22%2C%22FEMALE%22)%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-271845%22%20slang%3D%22en-US%22%3ERe%3A%20DATA%20VALIDATION%20FORMULA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-271845%22%20slang%3D%22en-US%22%3E%3CP%3Eplace%20the%20Data%20Validation%20on%20the%20cell%20that%20you%20prefer%20-%20then%20type%20on%20the%20source%20Male%2C%20Female%3C%2FP%3E%3CP%3Eyou%20can%20now%20have%20a%20selection.%3C%2FP%3E%3CP%3Epls%20see%20attached%20image.%3C%2FP%3E%3CP%3Ehope%20you%20can%20make%20something%20out%20of%20it.%3C%2FP%3E%3CP%3Ethanks..%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F56514iFEC4EC986C91A84E%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22DV-list.jpg%22%20title%3D%22DV-list.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Seth Krukowski
Occasional Visitor

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.

3 Replies

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

 

DV-list.jpg

try:
in cell F4 =IF(M5="M","MALE","FEMALE")

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.  

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies