Rounding Down

The simplest form of rounding is truncation. Any digits after the desired precision are ignored and dropped. The VBA Fix() function is an example of truncation. For example, Fix(3.5)is 3, and Fix(-3.5) is -3.

The Int() function rounds down to the highest integer less than the value. Both Int() and Fix() act the same way with positive numbers (truncating), but give different results for negative numbers: Int(-3.5) gives -4.

The Fix() function is an example of symmetric rounding because it affects the magnitude (absolute value) of positive and negative numbers in the same way. The Int() function is an example of asymmetric rounding because it affects the magnitude of positive and negative numbers differently.