# Discussions

View Only

## 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

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