Ceiling Integer
Solved
bidounet84
Posted messages
476
Status
Member
-
bidounet84 Posted messages 476 Status Member -
bidounet84 Posted messages 476 Status Member -
Hello,
I have this kind of line in my macro:
Because I want to display an integer.
However, originally this decimal number is for example 29.8. So the macro displays 29, while I would like to display 30 in this case.
Just so you know, rounding down or up.
Configuration: Windows / Chrome 63.0.3239.132
I have this kind of line in my macro:
SYNTHESE_LOU.Cells(ligne_SYNTHESE_LOU, colonne_SYNTHESE_LOU).Value = Int(Repartition / 100 * Qte)
Because I want to display an integer.
However, originally this decimal number is for example 29.8. So the macro displays 29, while I would like to display 30 in this case.
Just so you know, rounding down or up.
Configuration: Windows / Chrome 63.0.3239.132