Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use the CEIL() function in the same way as round - always "rounds" up.
HTH
Jonathan
Yeap. ceil() function will do exactly what you want and floor() will do exactly the opposite. 🙂
Agis
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
I would appreciate your help it works perfect
ur wc,if u are happy with tht..pls mark as correct.
If your questions is answered, please flag the correct answer so the topic is flagged as answered. Thank you.