Entereing an age and if statement in the same cell
 

I have an age formula in a cell based on d.o.b., which works, however,
all the blank cells for future use are returning the no. (#)109. I
would like to enter another formula (IF statement???) so that the cell
shows as blank or zero until data is enterend into the d.o.b. cell.

Thanks for any help anyone can give me on this...

Tracy

Entereing an age and if statement in the same cell
 

It would help if you were to post your formula and tell us what cell
(s) you are using, but generally you need to do something like this:

=IF(dob="","",your_existing_formula)

where dob is the cell that contains the date of birth (or is empty).

Hope this helps.

Pete

On Oct 16, 4:16*pm, Mithy1 wrote:
I have an age formula in a cell based on d.o.b., which works, however,
all the blank cells for future use are returning the no. (#)109. *I
would like to enter another formula (IF statement???) so that the cell
shows as blank or zero until data is enterend into the d.o.b. cell.

Thanks for any help anyone can give me on this...

Tracy