Rounding up to nearest 5

C

Chris Carlson

I have a user who is wanting to evaluate a doallar amount
and round it up to the nearest 5 amount. For example if
she has $16 in one cell she would like to round that
number up to $20. Or if she has $11, she wants it rounded
up to $15. How can I do this? Thanks.

Chris
 

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

Top