Extracting last 2 digits from a cell

[matthewpaul12]

Hi

Need some help, but not sure if the below will make sense, so here goes:

Assume cell A2 has a numerical value of 1489459. I am looking to capture just the last 2 digits of that number. The RIGHT(A2,2) formula gives me the correct output, but I think this formula formats the last 2 digits as text, not a number. So when I input a formula into another cell asking if those last 2 digits are greater than/equal to x, the formula doesn't work cause the RIGHT formula is classifying the data as text.

If my rambling above makes any sense, does anyone have any suggestions? I tried just changing the formatting of the cells with the RIGHT formulas to number, but that didn't make the IF greater than/equal to formulas work.

Thanks!

 

[Tim_Excel_]

=int(right(a2,2))

 

[matthewpaul12]

Thanks!