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
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.
To prevent returning a zero use with an if statement to handle values <2.5
This will work with any desired multiple.