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

I think your math is wrong. If you want to round to the nearest 5, Round(17,5) = 15 not 20.

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

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

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.