[jackrobyn1]

is there a formula i can put in cell C1 that will put the word "York" and
todays date whatever that happens to be on the day, i only want it to do this
if there is a number greater than 0 in cell A1.

In other words if A1 is 0 then i want C1 to be blank.
If A1 = anything larger than 0 then C1 should read "York" + todays date

thanks

[Bernard Liengme]

Here you a =IF(A1,"York " & TEXT(TODAY(),"dd/mm/yyyy"),"")
No need for =IF(A10, .... since Excel treats any non-zero value as TRUE
You can change the date format to suit your needs; I assumed York to be
York in Yorkshire UK
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"jackrobyn1" wrote in message
...
is there a formula i can put in cell C1 that will put the word "York" and
todays date whatever that happens to be on the day, i only want it to do
this
if there is a number greater than 0 in cell A1.

In other words if A1 is 0 then i want C1 to be blank.
If A1 = anything larger than 0 then C1 should read "York" + todays date

thanks

[Mike H]

Maybe

=IF(A10,"York " & TEXT(TODAY(),"DD/MM/YYYY"),"")

Mike

"jackrobyn1" wrote:

is there a formula i can put in cell C1 that will put the word "York" and
todays date whatever that happens to be on the day, i only want it to do this
if there is a number greater than 0 in cell A1.

In other words if A1 is 0 then i want C1 to be blank.
If A1 = anything larger than 0 then C1 should read "York" + todays date

thanks