What formula should I use?
If B2 has M inputed, then I want C2 to say 'Male'
Help!
MacBook Air, OS X Yosemite (10.10.5)
The following would be the formula in C2: IF(B2="M","Male","")
The following would be the formula in C2: IF(B2="M","Male","")
And assuming this is a question with only two possible answers, you might want to add to Foxfirth's formula:
C2: IF(B2="M","Male","Female")
Regards,
Barry
Thankyou! 🙂
Hi Appleman,
It is a slippery slope.
= IF(B2="M","Male","") will only return "Male"
=IF(B2="M","Male","Female") will return "Female" if the cell is blank. This can work if you are using a popup with only two values.
=IF(B4="M","Male",IF(B4="F","Female","")) will return "Male" for "M", Female" for "F" and nothing for a blank.
quinn
Formula
