Hi All,
I'm working on a retirement spreadsheet, and having trouble with a formula.
In cell I9, I have a formula that calculates your age with 25 years of service.
What I'm looking for, is a formula that tells me whether or not you've reached 55 years old or not, and if you do, it tells me you did. This formula goes in cell I11.
Here's what I'm working with, and can't get this to work correctly, if cell I9 is blank, I want this cell (I11) to be blank.
=IF(I9<>"",I9>54,"Value is 55 or greater","")
Hmmm - what am I missing??
Thanx in advance...LT
Bookmarks