Skip to main content
Question

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

  • November 16, 2016
  • 0 replies
  • 338 views
Forum|alt.badge.img+11
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...

  • anomDiebolt
  • Registered
  • November 16, 2016
I think your math is wrong. If you want to round to the nearest 5, Round(17,5) = 15 not 20.
Forum|alt.badge.img+11
  • BuildPro
  • Author
  • Registered
  • November 17, 2016
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
  • anomDiebolt
  • Registered
  • November 17, 2016
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
  • PhilPinkham
  • Registered
  • July 15, 2017
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.
Terms & ConditionsAccessibility statement