Thread: Round Up by a factor not by a digit [MROUNDUP(number,multiple)]
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default Round Up by a factor not by a digit [MROUNDUP(number,multiple)]
=CELING(number,multiple)
--
David Biddulph

wrote in message
oups.com...
3 questions really, first most relevant and important:

1) I want the functionailty of mround() i.e. rounding by a factor, but
I want it to be rounded up as in roundup, but roundup rounds up by a
specified number of digits not a factor.
Can this be achieved without code?
....


Reply With QuoteReply With Quote