Another command to IF forumla needed

[Rumpus24]

Hi

I am trying to add another command into my IF formula so that if a gender isn’t ‘F’ or ‘M’ (i.e. just blank) it will return a blank cell, rather than Male. I’m not sure if it’s an AND or OR that I need.

Bit of background - in my original data, column A links through to a database of staff details. The main database gets refreshed so cells move up and down all the time depending on when people leave and start. I have created a formula to display a blank cell if there is no data in that cell to pull through, rather than display a load of 0’s.

With the current formula in column B, I need from cell B11 downwards to read blank if there is no data in cell A11, so I need an ‘otherwise’ command in the formula I just can’t get my head around how to do it I’m sure its simple!

Thanks in advance

[Sam Capricci]

there are a few ways but this is one...
=IF(A3="F","Female",IF(A3="M","Male",""))
if any of your data has spaces after you might make it this instead.
=IF(A3="F*","Female",IF(A3="M*","Male",""))