If 100.00% =Yes Formula

[luisitocarrion1900]

I need a formula that i can place in F:2 that if I:2 equals 100.00% entered Y in F:2 if not enter N

I though that maybe something like this would work but is not

[FONT=&quot]=IF(EXACT(I2,"100.00%"), "Y", "N")[/FONT]

 

[Michael M]

Try

=IF(I2=1, "Y", "N")

 

[Paul Ked]

If I2 is formatted as % then =IF(I2=1,"Y","N")

 

[luisitocarrion1900]

Thank you so much, it worked like a charm