Rounding numbers if more than certain value

[mrxlsx]

Hi all, Good afternoon!

I have some scores ranging from 10 to 100 with two decimal values. I want to round them as follows (in another column taking these values, not a formatting solution).

Scores Rounded

15.25	15.00
15.49	15.00
15.50	15.00
15.51	16.00
15.65	16.00
15.99	16.00

<tbody>
</tbody>

In essence, it is if anything is <= .50 then it is the same value with the same decimal figures. Anything > .50 it should be rounded to the next integer. I searched a lot for this kind of customized solution, but in vain. Advance thanks for all who try this.

 

[AliGW]

Try this:

=IF(A1-int(A1)>0.5,int(A1)+1,int(A1))

 

[tusharm]

=ROUND(A2-0.01,0) where A2 contains one of the values to 2 decimal places.

Hi all, Good afternoon!

I have some scores ranging from 10 to 100 with two decimal values. I want to round them as follows (in another column taking these values, not a formatting solution).

Scores Rounded

15.25	15.00
15.49	15.00
15.50	15.00
15.51	16.00
15.65	16.00
15.99	16.00

<tbody>
</tbody>

In essence, it is if anything is <= .50 then it is the same value with the same decimal figures. Anything > .50 it should be rounded to the next integer. I searched a lot for this kind of customized solution, but in vain. Advance thanks for all who try this.

 

[mrxlsx]

Thanks AliGW and Tushar. Tushar's solution is the apt solution for my problem. Thank you both.