formula to return last 2 or 3 digits in cell

hi! I'm trying to write a formula but i've been unsuccessful. i need,
If last 3 digits in referencing cell (i.e. c5) are = or > 100, return last 3 digits. if last 3 digits are less than 100, return last 2 digits.
I'd appreciate any help

Maybe something like this

=IF(RIGHT(A1,3)>=100,RIGHT(A1,3),RIGHT(A1,2))+0

Try:

Formula:

Please Login or Register  to view this content.

You are very welcome and glad you have something that works for you.

You're welcome. Thanks for the rep.