Excel 2007 : Making a cell blank or show message

Hi, I am trying to make a cell show a message if the adjacent cells date is less than sixty days - the following works fine for that:

=IF(Q11<=TODAY()+60,"Expires 2 month","")

But what I want to do is for the cell to remain blank if the adjacent cell has no value in it - any thoughts?

Cheers

NSM

Hi,

first, test if there is a value in Q11, if not, return a blank, otherwise use the If statement you already have.

=IF(ISBLANK(Q11),"",IF(Q11<=TODAY()+60,"Expires 2 month",""))

hth

or

=IF(AND(ISNUMBER(Q11),Q11<=TODAY()+60),"Expires 2 month","")