thanks Pete_UK, much appreciated for the reply :)

thanks community as well :)

--
oldLearner57


"Pete_UK" wrote:

So you want to round up to multiples of 5? Try this:

=CEILING(A1,5)

Hope this helps.

Pete

On Apr 22, 3:33 pm, oldLearner57
wrote:
hi community

how can i do a roundup to value as....

example:

if my value is 964, I want to round to 965 and if another value is 1057, it
will round to 1060

is there possible to do such task?

thanks community for the assistance

--
oldLearner57