Thread: how do i use the roundup function
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Luke M Luke M is offline
external usenet poster
  
Posts: 2,722
Default how do i use the roundup function
You can actually use negative numbers to indicate how many places left of
decimal to round.
E.g.,

=ROUNDUP(11,-1)
evaluates to 20.

CEILING is nice for when you need to roundup to a common multiple of a
number other than 10.
E.g.
=CEILING(11,5)
evaluates to 15.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"willemeulen" wrote:


Roundup works up to 1 decimal, if you want let say round it up to the 10
(11 becomes 20, 25 becomes 30 etc you could use the CEILING FUNCTION

Cheers

W


--
willemeulen

Blink1 *Willem van der Meulen* BSc Soil & Water Eng (Netherlands)
------------------------------------------------------------------------
willemeulen's Profile: http://www.thecodecage.com/forumz/member.php?userid=285
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=105210


Reply With QuoteReply With Quote