Hi,

I have a very basic question. thanks for helping.

if the cell has "Male" or "female" then returning "Y", otherwise leaves blank

why the following is not working? and i want to make sure it leaves Blank instead me giving me #value or #N/A
=if(a1=(or("male","female"),"y","")

i know i can use two conditional statements to make this work, but is there a way to use just one if and use some other functions? say OR?

thank you.