Hello,

The comparison in your formula will always be False, because A1 is a number and it is compared with a text string. What you could do instead is

=IF(RIGHT(TEXT(A1,"0.00"),2)="01","yes","no")

The formula formats the number with two decimal points (regardless of what is actually showing in the cell) and converts it into a text string. Then the rightmost two characters are inspected and compared with the text "01"

This way, text is compared with text.

cheers,