When you want to round to the nearest cent, just use the half even mode. half ceil— the nearest neighbor, equidistant values go towards the larger number. half floor— the nearest neighbor, equidistant towards the smaller number. Rounding at a glance If all this text sounds daunting, here...
To round to the nearest cent, use: Tax: Round([Amount] * [TaxRate], 2) Rounding down To round all fractional values down to the lower number, useInt(): Int([MyField]) All these numbers would then be rounded down to 2: 2.1, 2.5, 2.8, and 2.99. ...