Entereing an age and if statement in the same cell

  • Thread starter Thread starter Mithy1
  • Start date Start date
M

Mithy1

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
 
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
 
Back
Top