Ditch the double quotees around the percentages

=if(k2=19,65%,if(k2=20,75%))

"nolechik" wrote:

I have a report I am attempting to automate as much as possible. What I have
done is put in the following:
Cell J is a current %
Cell K is my product type (a number 19,20)
Cell L is =if(k2=19,"65%",if(k2=20,"75%"))
Cell M I want it to tell me whether the % in cell J is more then L, when I
input the formula =if(j2=L2,"Yes","No") it does not change but if I delete
the formula in L and type a % in it works....HELP