rounding issue

[#1]

4.255, when round it , i become 4.25instead of 4.26. 

i want it to be 4.26,which should be correct in my understanding

[Sokkorn]

Hi,

Can you try to create Text Object and use this expression =Round(4.255,0.01) then give me the result. Just want to know it cause from your table or function.

Regards,

Sokkorn

[#3]

=Round(4.255,0.01)  , it comes out 4.26

but

=round(4.655,0.01), it comes out 4.65

why?

[Sokkorn]

Hi,

Can you try this one

=Ceil( 4.655 , 0.01 )

Rgds,

Sokkorn