Hello, I have an issue where I am trying to populate a column based on data from another column. I want to take data from one column and abbreviate it in another.

Example: "I2=100%", what is the right formula to have C2 populated with "1"

I tried using =IF(L2="100%","1") but it comes up with an error. 

Another thread suggested =IF(L2="100%","100%","OG1") but that populates the cell regardless if there is data entered or not. 

I feel like I'm close, any suggestions would be greatly appreciated.

"100%" is a text value. If I2 contains a number formatted as a percentage, you shouldn't use "100%" but 100% without the quotes:

=IF(I2=100%,1,"")