Or you could shorten that to =IF(LEN(A1)0,"Closed",""), as it is unlikely
that LEN will be negative. :-)
--
David Biddulph


"Gary Brown" wrote in message
...
=IF(LEN(A1)<0,"Closed","")
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Dave" wrote:

Hi all,

I've got an issue where I need a formula that when I put a date (or any
value) in cell A1, the text 'Closed' is automatically entered in cell B1
- I'm sure I've seen it somewhere before (probably used it too), but
I've searched in vain - can anyone help?

TIA


Dave
.