Prev: Average % - this should be easy?
Next: formula to calculate amount of hours downtime spent in days
From: &rew on 26 Jan 2010 21:42
Or perhaps (in B1): =IF(ISBLANK(A1),"","Closed") ?

"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
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: Average % - this should be easy?
Next: formula to calculate amount of hours downtime spent in days