Return N/A if date field is blank

[eganmom]

I am not great at excel formulas but have managed to cobble together an IF/AND string of formulas in order to convert a date in one column (col C) into an age range in another column (col D). However, if there is no date in col C, I want it to return N/A. Instead it is giving me “over 65” which is one of age ranges. What do I need to add to this or edit in order to obtain N/A for a blank cell?

 

[Joe4]

Welcome to the Board!

Wrap your original formula in an IF formula, like this (example for row 2):
=IF(C2="","NA",your original formula)

 

[eganmom]

 

[eganmom]

Welcome to the Board!

Wrap your original formula in an IF formula, like this (example for row 2):
=IF(C2="","NA",your original formula)

OMG, thank you so much! I have been googling and trying different things and nothing was working! Much appreciated Joe4!

 

[Joe4]

You are welcome.
Glad I was able to help!

 

[eastrand]

You can also enclose your formula in an IFERROR( ) function. IFERROR(your original formula,""). Depending on how much data there is, this could calculate little faster.

 

[Joe4]

You can also enclose your formula in an IFERROR( ) function. IFERROR(your original formula,""). Depending on how much data there is, this could calculate little faster.

I don't think that will work in this case.
Their formula does not appear to returning an error, it is returning an unwanted result.
Note that It is not returning the "#N/A" error; they just WANT it to return "NA" when column C is blank.

 

[eastrand]

I don't think that will work in this case.
Their formula does not appear to returning an error, it is returning an unwanted result.
Note that It is not returning the "#N/A" error; they just WANT it to return "NA" when column C is blank.

You are correct. I need to read more carefully.