Ceiling Integer

Solved
bidounet84 Posted messages 476 Status Member -  
bidounet84 Posted messages 476 Status Member -
Hello,

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

2 answers

  1. bidounet84 Posted messages 476 Status Member 88
     
    Perfect, thank you, it works.
    0