Round Up

  • Thread starter Thread starter Paul Hammond
  • Start date Start date
P

Paul Hammond

I am looking for a function that will duplicate the Round
Up function in Excel.

TIA

Paul Hammond
Richmond, Virginia
 
Thanks, I'm going to use this. I found one small change
I had to make for my purpose. I had to multiply my value
* 100 then divide the final result by 100 to round up to
the 2nd decimal place. Also I had to test for negatives
and remove the minus sign to get the proper result.

IIf([AmountField]>0,Abs(Int(-([AmountField]*100))/100),Int
(([AmountField]*100))/100)

Not sure if I got the parens right here but it does work
in my query, TG.

PH
-----Original Message-----
Try this:

=ABS(INT(-[YourAmountField))

Regards,

ET Sherman
-----Original Message-----
I am looking for a function that will duplicate the Round
Up function in Excel.

TIA

Paul Hammond
Richmond, Virginia
.
Click to expand...
.
Click to expand...
 
Back
Top