Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    2

    Unanswered: Rounding increments

    I'm thinking this is a quick fix, but I'm frustrated trying to figure it out. It's a budgeting exercise in which the number I calculate I then would like to round to the closest $25 increment. So:

    $45,323 = $45,325
    $34,165 = $34,175
    $101 = $100

    I would greatly appreciate any help on the subject. Thank you.

  2. #2
    Join Date
    Mar 2004
    Location
    Minnesota, USA, Earth
    Posts
    65

    Try this...

    I know you're going to slap your forehead, but we all have these days (myself more so than the average).

    =ROUND(A1/25,0)*25

    -Mike

  3. #3
    Join Date
    May 2004
    Posts
    2
    Thanks for the assist on that one! Greatly Appreciated

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •