Round Up!

[Questions King]

Hi everyone!

I just need to ask how I round up my amount like:

49.01 and I need to be 50.00

49.95 and also to be 50.00

May I know how? thank for your reply!

[LaurenKuhlman]

Truncate + 1

[Vaughan]

Truncate + 1 will make 49.00 -> 50.00

If [ Int( number ) = number ; number ; Truncate( number ) + 1 ) ]

[comment]

Try the Ceiling() function…

[David Jondreau]

Ceiling() is the function to use.

[Questions King]

Thank for reply! I try first...

[LaurenKuhlman]

I misread your post. Ceiling is best.