If you have a formula returning a blank "" then ISBLANK will not identify
that as a blank cell..
=IF(ISBLANK(Y39),"Month Unknown","")

If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Do you mean

=IF(Y39="","Month Unknown","")

'If you have date in Y39
=IF(Y39,TEXT(Y39,"mmmm"),"Month Unknown")

If this post helps click Yes
---------------
Jacob Skaria


"TDMP" wrote:

Hi,

It is possible to use If ISBLANK to find a blank cell lest say Y39 and if it
is blank inout the text Month Unknown into the cell?

If so please tell me what is the syntax as I ahve tried and no luck...if not
can you offer an alternative?

Thank you