if statement see "Male" or "Female" returning "Y" otherwise leave blank

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.

Hi,

Please Login or Register  to view this content.

HTH
Carim

thanks a lot.

You are welcome ...

Carim