Rounding up to nearest 5

  • Thread starter Thread starter Chris Carlson
  • Start date Start date
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
 
Back
Top