formula needed please

[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 are: =IF(A1,"York " & TEXT(TODAY(),"dd/mm/yyyy"),"")
No need for =IF(A1>0, .... 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

 

[Mike H]

Maybe

=IF(A1>0,"York " & TEXT(TODAY(),"DD/MM/YYYY"),"")

Mike