Trying to fill in empty blank cells

I've got a spreadsheet that has Gender, Ethnicity, Birthdate, Age, Year Joined, and Age Group. There are a number of cells where people chose not to share that information.

For both Age and Age Group, I created formulas to figure those out.

For Birthdate, if they didn't give an age, Excel defaults to 120 but I would like to write a formula that says "if there is no date in Birthdate, this cell (Age) should equal Not Given. The same is true for Ethnicity and Gender. I thought that I could use an if(isblank) formula for those two rows, but it's not working. I tried =if(isblank(C9),"Not Given", ""), but that doesn't work. As you'll see in my example, I hard coded Not Given for Ethnicity, but that's not a good fix.

Any help is appreciated.

Chip

This means "not equal to":

=IF(D2 is NOT equal to "Not Given", ...

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.