Rounding up to 5 cents

  • Thread starter Thread starter Wakka
  • Start date Start date
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.
 
Try the following to round positive numbers up to the next 5 cents.

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