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

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

Using Custom Functions from Oracle DB 2
Update FROM a Linked Table 2
Combo Box column 1
Rounding number 15
Context Menus 1
Mangled Subquery 6
Lost Audio after converting to pps 4
I need to always Round UP if greater than zero at all. HOW? 6

Back
Top