Two formulas without creating a circular formula

[Lilyk70]

Hello All,

I am currently using a DOB against todays date to figure out the age of a person. I am using =INT((F$4-E38)/365.25) so F$4 is todays date. In the blank rows it is given me the answer 111. Can you please tell me if there is a way i can change this unused row showing 111 to showing nothing at all until the row has the information? I thought about using =IF(F47<100,F47," ") but not sure of a way of adding the two formulars together in one output cell without creating a circular formula.

Appreciate any help. New and learning fast

Lily

[teylyn]

Hello,

kind of hard to tell without seeing your workbook. Blank rows? F47?