IF help

M

Mark Kelly

I am building a calendar that records events by month. For example I would
type an event in the Jan 04 cell. I would like to have the Jan 05 cell
return the entry with an ³04² in front of it.
I am able to use the IF function to return the value in the Jan 05 cell
equal to the Jan 04 cell by using >0.

I am asking for help with identifying that the returned value came from 04

Thank you

Mark
 
R

Roger Govier

IF helpHi Mark

Not sure if I understand your question fully, but if in row 1 you have dates starting in A1 with 01/01/2004 and you enter an event in A2, then the following formula in M2 might be what you are looking for
=IF(A2="","",TEXT(A$1,"yy")&" "&A2)
Copy across through M3 to X2 and down for as many rows as required.

--
Regards
Roger Govier
I am building a calendar that records events by month. For example I would type an event in the Jan 04 cell. I would like to have the Jan 05 cell return the entry with an "04" in front of it.
I am able to use the IF function to return the value in the Jan 05 cell equal to the Jan 04 cell by using >0.

I am asking for help with identifying that the returned value came from 04

Thank you

Mark
 
Top