Rounding a calcuation

[crowegreg]

Within a text box, I'm calcuating an amount. I would like to round that amount up to the closest $5. An example would be if the calculation is $486.50, I'd like it to be rounded to $490.00. Thank you in advance!!

[JoeM]

This is kind of a bizarre method, but it works:

=int(((your calculation here)/5)+.999)*5

[crowegreg]

I'll give your's a try. I've been working on it, but my code is much longer.

[crowegreg]

That worked perfectly!! Thanks