What is the formula to round up or down to the nearest ""5
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...
Forum Discussion
I think your math is wrong. If you want to round to the nearest 5, Round(17,5) = 15 not 20.