With Visual Basic you mean VBA?
To get the result rounded to whole number, the formula must be
Code:
=ROUND(AveCutFill/1000,0)
To get the result rounded to 1st decimal, the formula must be
Code:
=ROUND(AveCutFill/1000,1)
, etc.
But you have to remember, that Access VBA uses 'banker's rounding':
Round(0.5,0) = 0, Round(1.5,0) = 2, Round(2.5,0) = 2, etc.
More about 'banker's rounding' and how to avoid it you can read e.g. here https://www.techonthenet.com/access/...eric/round.php
NB! This behavior of ROUND() function applies to VBA only! E.g. Excel worksheet function ROUND() rounds in traditional way.