You're welcome - thanks for feeding back.

Pete

On Apr 22, 4:30*pm, oldLearner57
wrote:
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- Hide quoted text -

- Show quoted text -