Rounding

L

Luis

I need help again:

I have a query in which I have the following:
Dose Billin Unit Billed Units
350 480 1
240 480 1
200 480 0

Billed Units are rounding to the nearest tenth. How I
can make it so it rounds to the closest following
number..For instance, 200/480 = 0.416 in which for
billing purpose, I will bill 1 unit instead of 0 or 1/2...
The samething if I have 3.14 as a result. I will bill
for 4 instead of 3 or 3.50

Thank you in advance.
 
Top