Rounding up to 5 cents

W

Wakka

I have a field "Adjusted Totals" that is a currency
value. Does anyone know how to round this UP to the
nearest 5 cents?
Cheers.
Wakka.
 
J

John Spencer (MVP)

Try the following to round positive numbers up to the next 5 cents.

-Int(-[Adjusted totals]*20)/20
 

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

Rounding to the Left of the Decimal 2
in access, round up to nearest fraction(.5) 1
Divide a # into 3 #'s rounded to a whole # 9
Round up or down to nearest 5, but not 10 2
Format Currency field into zero filled text field 1
I need to always Round UP if greater than zero at all. HOW? 9
Excel:How do I exactly sum 3 rounded curency numbers 1
round to nearest 5 2

Top