Yeah! Minor tweak and it's working: function roundUp500 theNumber return trunc((theNumber-1)/500+1)*500 end roundUp500 Many thanks Mark and Brian. I love this group. Hugh Senior FLCo On 3 mrt 2011, at 18:06, FlexibleLearning wrote: > Here's a poser for you all... > > How to round a number UP to the nearest 500? > > > Hugh Senior > FLCo