Rounding Up

VBA does not have a specific round-up function. However, for negative numbers, both Fix() and Int() can be used to round upward, in different ways:

• Fix() rounds towards 0 (up in the absolute sense, but down in terms of absolute magnitude). For example: Fix(-3.5) is -3.5.

• Int() rounds away from 0 (up in terms of absolute magnitude, but down in the absolute sense). For example: Int(-3.5) is -4.