I have a database where 0=Days, 1=Weeks, 2=Months, 3=Years... I need the formula to show their true names as text, so I can then link to a frequency period (numeric) as a text string. So I then have 1 Day, 2 Week, 4 Year, etc in all combinations as per data. Which Formula do I use? Again, the data I have is 0-3, but I want to trasnlate the numbers so 0=Days, 1=Weeks, 2=Months, 3=Years. Please help! Thanks.
You need to give some examples
How can 2 = Months when there are 12 months in a year, similarly for weeks how can a single digit represent up to 52 weeks
Ian