IF Command

[ianripping]

In column A I have values

1st
2nd
3rd

and in Column B I want it to say

January 04
January 04
January 04

I only want January 04 to appear when something is entered into the
adjacent Column A cell

Can anyone help?

 

[Bob Phillips]

B1: =IF(A1<>"","January 04","")

and copy down.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Frank Kabel]

Hi

try
=IF(A1<>"",DATEVALUE("2004-01-01"),"")

Frank

 

[ianripping]

this works great thankyou!

 

[Frank Kabel]

your're welcome
Frank

 

[ChrisJForeman]

In cell B1, for example, code:
IF(ISBLANK(A1),"","your text")

HTH

Chris