Discussions

Expand all | Collapse all

What is the formula to round up or down to the nearest ""5

  • 1.  What is the formula to round up or down to the nearest ""5

    Posted 11-15-2016 21:15
    Need a formula for the following:

    If [gal to order] is between 17 & 22, round to 20
    If [gal to order] is between 22.01 & 27, round to 25

    etc...


  • 2.  RE: What is the formula to round up or down to the nearest ""5

    Top
    Contributor
    Posted 11-15-2016 22:17
    I think your math is wrong. If you want to round to the nearest 5, Round(17,5) = 15 not 20.


  • 3.  RE: What is the formula to round up or down to the nearest ""5

    Posted 11-16-2016 22:45
    No math involved. I want all numbers between 17 & 22 to round to the number 20. Some will round up, some will round down. Also, 22.01 through 27 would round to 25...so on and so forth. Thx


  • 4.  RE: What is the formula to round up or down to the nearest ""5

    Top
    Contributor
    Posted 11-17-2016 13:31
    I can't image a world without Math.

    Numb3rs Scene: Everything is numbers, Math is everywhere
    https://www.youtube.com/watch?v=vFRTgr7MfWw

    If(
      [gal to order] >=17 and [gal to order] <22, 20,
      [gal to order] >=22 and [gal to order] <27, 25
    )

    An amazing story about an amazing mathematician:

    Srinivasa Ramanujan
    https://www.youtube.com/watch?v=Y7Ufxl-zSRI


  • 5.  RE: What is the formula to round up or down to the nearest ""5

    Posted 07-14-2017 20:58
    Round([gal to order]/5)*5

    To prevent returning a zero use with an if statement to handle values <2.5

    This will work with any desired multiple.