Prev: Average % - this should be easy?
Next: formula to calculate amount of hours downtime spent in days
From: Dave on 26 Jan 2010 11:13
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
From: "David Biddulph" groups [at] on 26 Jan 2010 11:41
Not conditional format, but in B1 you can use the formula
=IF(A1="","","Closed")
--
David Biddulph

"Dave" <dave(a)nospam.com> wrote in message
news:JwE7n.24409$AJ7.20557(a)newsfe17.ams2...
> 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


From: Gary Brown on 26 Jan 2010 12:22
=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
> .
>
From: "David Biddulph" groups [at] on 26 Jan 2010 12:42
Or you could shorten that to =IF(LEN(A1)>0,"Closed",""), as it is unlikely
that LEN will be negative. :-)
--
David Biddulph


"Gary Brown" <GaryBrown(a)discussions.microsoft.com> wrote in message
news:96C402BA-4772-456B-B479-0151E4B6827D(a)microsoft.com...
> =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
>> .
>>


From: Dave on 26 Jan 2010 13:28
On 26/01/2010 16:13, 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

Thank you for your help gentlemen - I now feel rather stupid :(

--

Regards

Dave
 |  Next  |  Last
Pages: 1 2
Prev: Average % - this should be easy?
Next: formula to calculate amount of hours downtime spent in days