ROUNDUP, without ROUND

[#1]

ROUNDUP, without ROUND

Best regards

I wish rounding the result to the maximum without ROUND, since it makes if the decimal is 5 or above is rounded, otherwise it does not. Example: round (2.4) returns 2; round (2.6 returns 3), but I need you round all, example: XX (2.2) = 3; XX (2.5) = 3. something similar to excel, when used "roundup"

I would appreciate your valuable assistance

thank you very much

[jonathandienst]

Use the CEIL() function in the same way as round - always "rounds" up.

HTH

Jonathan

[Agis-Kalogiannis]

Yeap. ceil() function will do exactly what you want and floor() will do exactly the opposite. 🙂

Agis

[buzzy996]

from reference manual,

ceil( x [ , base [ , offset ]] )

Rounding of x upwards to the nearest multiple of base with an offset

of offset. The result is a number.

Examples:

ceil( 2.4 ) returns 3

ceil( 2.6 ) returns 3

ceil( 3.88 , 0.1 ) returns 3.9

ceil( 3.88 , 5 ) returns 5

ceil( 1.1 , 1 , 0.5 ) returns 1.5

[#5]

I would appreciate your help it works perfect

[buzzy996]

ur wc,if u are happy with tht..pls mark as correct.

[oknotsen]

If your questions is answered, please flag the correct answer so the topic is flagged as answered. Thank you.