Rounding for Inventory

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Number Field Automatically Rounding Decimals 3
Rounding Decimals 14
Round to 0.5 2
Rounding UP - always 2
Excel Excel 2007 won't stop rounding down my formula results! 5
Rounding problem 2
rounding is ignored in calculated control 4
Access stripping decimal places in query 1

Back
Top