BuildProQrew Captain9 years agoWhat is the formula to round up or down to the nearest ""5Need 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_Qrew Elite9 years agoI think your math is wrong. If you want to round to the nearest 5, Round(17,5) = 15 not 20.
Related Contentsyntax help with formulaDelete Formula Button ErrorFormula AssistanceFormula Url ButtonsURL formula -API_RunImport