Hi @Dennisbur,
You're on the right track with the Ceiling() and Floor() functions. Those will always return an integer, so what we can do is modify the input so that an integer return works for us. Specifically, adding a coefficient and a final rescaling so that we apply the ceiling function at the right place in the formula.
Take your first example, 13.24. Imagine a simple case where you wanted to ceiling the first decimal place, so a result of 13.3. You could do the following:
![julian_0-1672580093773.png julian_0-1672580093773.png](https://community.jmp.com/t5/image/serverpage/image-id/48743iE765774CCA202CB1/image-size/small?v=v2&px=200)
This will return 13.3, because Ceiling() is acting on the value 132.4, and the ceiling of that value is 133. Dividing that by 10 returns us to the base units.
Another way to write this is using the reciprocal of the units place you want to ceiling, which is the 0.1 place:
![julian_1-1672580240396.png julian_1-1672580240396.png](https://community.jmp.com/t5/image/serverpage/image-id/48744iCCFBE64049F6FADB/image-size/small?v=v2&px=200)
So, for your case, where you wish to Ceiling() or Floor() at the 0.05 the value in the :Number column, you need:
![julian_2-1672580282036.png julian_2-1672580282036.png](https://community.jmp.com/t5/image/serverpage/image-id/48745iB2C40EC9C3627BE7/image-size/small?v=v2&px=200)
![julian_3-1672580294575.png julian_3-1672580294575.png](https://community.jmp.com/t5/image/serverpage/image-id/48746i42EE30B5B815B275/image-size/small?v=v2&px=200)
//Ceiling
Ceiling( 0.05 ^ (-1) * :Number ) / 0.05 ^ (-1)
//Floor
Floor( 0.05 ^ (-1) * :Number ) / 0.05 ^ (-1)
These formulas return the answers you are looking for.
![julian_4-1672580335102.png julian_4-1672580335102.png](https://community.jmp.com/t5/image/serverpage/image-id/48747i9547F4324D709006/image-size/medium?v=v2&px=400)
I've attached the table here with those formulas.
I hope this helps!
@julian