roundup value

[oldLearner57]

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

 

[Peo Sjoblom]

=CEILING(A1,5)


--


Regards,


Peo Sjoblom

 

[Pete_UK]

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

=CEILING(A1,5)

Hope this helps.

Pete

 

[oldLearner57]

thanks Peo Sjoblom, much appreciated for the replied

 

[oldLearner57]

thanks Pete_UK, much appreciated for the reply

thanks community as well

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete

thanks Pete_UK, much appreciated for the reply

thanks community as well  

--
oldLearner57





- Show quoted text -