I want to ask a question about usage of RoundUp function,
In a vba application, I need to use RoundUp ( or Ceil) function, even if I used
round function before billions of time, I've never used round up function
before. So I'm trying to use below example codes but they are not working;
Range("B2").Value = RoundUp((Range("A1").Value / Range("A2").Value), 0)
-----
Below example codes are workings;
Range("B2").Value = Round((Range("A1").Value / Range("A2").Value), 0)
or
Range("B2").FormulaR1C1 = "=ROUNDUP(R[-1]C[-1]/RC[-1],0)"
so how may I use roundup function with variables such as (Range("A1").Value