Hi - I'm trying to figure out a problem I'm having with my IF formula. See
below, I had to add "yr" after my numbers or else it came up blank. I want to
be able to put in just the number 1, 2, 3, 4 or 5 with out the yr behind it
and figure out my percent. Can someone please help me? Thanks in advance!

=IF(C19="1yr",1%,IF(C19="2yr",2%,IF(C19="3yr",3%,I F(C19="4yr",4%,IF(C19="5yr",5%,"")))))