rounding down

Question

hello all,
i want to round numbers down with excell VBA. For example, if number is 4.88, result must be 4.
how can i do that?
thanks

Answer 1

Check an example:

Dim x As Double
x = 4.88

Dim result As Integer
result = WorksheetFunction.Floor(x, 1) ' result: 4

See also the Floor_Math and Floor_Precise functions in documentation.