mrxlsx
Board Regular
- Joined
- Dec 15, 2012
- Messages
- 95
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
[TABLE="class: grid, width: 100, align: left"]
<tbody>[TR]
[TD]15.25[/TD]
[TD]15.00[/TD]
[/TR]
[TR]
[TD]15.49[/TD]
[TD]15.00[/TD]
[/TR]
[TR]
[TD]15.50[/TD]
[TD]15.00[/TD]
[/TR]
[TR]
[TD]15.51[/TD]
[TD]16.00[/TD]
[/TR]
[TR]
[TD]15.65[/TD]
[TD]16.00[/TD]
[/TR]
[TR]
[TD]15.99[/TD]
[TD]16.00[/TD]
[/TR]
</tbody>[/TABLE]
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.
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
[TABLE="class: grid, width: 100, align: left"]
<tbody>[TR]
[TD]15.25[/TD]
[TD]15.00[/TD]
[/TR]
[TR]
[TD]15.49[/TD]
[TD]15.00[/TD]
[/TR]
[TR]
[TD]15.50[/TD]
[TD]15.00[/TD]
[/TR]
[TR]
[TD]15.51[/TD]
[TD]16.00[/TD]
[/TR]
[TR]
[TD]15.65[/TD]
[TD]16.00[/TD]
[/TR]
[TR]
[TD]15.99[/TD]
[TD]16.00[/TD]
[/TR]
</tbody>[/TABLE]
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.
Last edited: