I'm trying to create an if statement with multiple values but it
doesn't seem to be working.

ie...I have a column that has different values (1,2,3,4,5). 1=daily,
2=weekly, 3=monthly, 4= quartely and 6=annually. I would like to have
another cell with the associate value. So, if a1=1 then daily, if a1=2
then weekly, if a1=3 then monthly, etc...

How would I do this?