Rounding for Inventory

D

Dan

the I have a calculated field in a report. I need calc field to round to 2
decimal places and if the decimal is greater than .00 (from .01 to .99) then
the decimal should equal .5 . I use this for inventory counting purposes i.e
if a bottle is opened it is counted as 1/2 a bottle. Can this be done? Thanks.
 
A

Al Camp

Dan,
Not sure how you'll be using this but... the logic would be...
If CalcVal - Int(CalcVal) > 0 Then
CalcVal = Int(CalcVal) + 0.5
End If
 
Top