I am looking for a formula that allows me to have a specific text if the value in the cell selected is between 19xx and 19yy. I thought of using IF but can't figure it out... :(
If the value is greater than 1967 and less than 1977 value = 30s

Nested IFs (http://www.cpearson.com/excel/nested.htm)

Look around this site if this link is not exact or close to what you need.