PDA

View Full Version : Help - Range Values Selection



mitko007
07-21-2008, 09:18 PM
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
07-21-2008, 10:01 PM
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
07-21-2008, 11:20 PM
Thank you for the help. It worked perfectly !!!

ilyaskazi
07-22-2008, 05:01 AM
Please mark this thread as 'Solved' by clicking 'Thread Tools' menu above...