Thread: How do I get MROUND to only round up to the next multiple.
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
  
Posts: 1,231
Default How do I get MROUND to only round up to the next multiple.
gmac wrote...
I do not wish to get a lower number when rounding to a miltpile of it.
I need to combing the MROUND and ROUNDUP.

Don't use MROUND. Instead of

=MROUND(x,n)

use

=ROUNDUP(x/n,0)*n

Reply With QuoteReply With Quote