Help - Range Values Selection

[mitko007]

Hi,
i have the following issue. I have a big Range of Values. Some of the values have the same decimal part and these are the ones i need to select (ex. 10.12, 10.25, 10.33, 11.25 - the ones with .25 are interesting for me)
Is there any option to get the value of the decimal part. I thought of converting them to strings and than cutting off the last 2 digits but there might be some better way of doing it.
Thanks you in advance...

[ilyaskazi]

Assuming your data is on Column-A put the formula given below in Cell-B1...

=IF(RIGHT(A1,2)="25",ROUND(A1,0),A1)

The above formula checks the last 2 digits for number '25' and will remove them else if not found then will kept same.



...

[mitko007]

Thank you for the help. It worked perfectly !!!

[ilyaskazi]

Please mark this thread as 'Solved' by clicking 'Thread Tools' menu above...