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

=CEILING(A1,5)


--


Regards,


Peo Sjoblom



"oldLearner57" wrote in message
...
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

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

thanks Peo Sjoblom, much appreciated for the replied
--
oldLearner57


"Peo Sjoblom" wrote:

=CEILING(A1,5)


--


Regards,


Peo Sjoblom



"oldLearner57" wrote in message
...
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

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

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 -