Thread: How do I get MROUND to only round up to the next multiple.
View Single Post
  #5   Report Post  
ergeg ergeg is offline
Junior Member
  
Posts: 1
Default
=IF(MROUND(A1,x)<=A1,MROUND(A1,x)+x,MROUND(A1,x))

Will round A1 UP to the next number divisible by x.
Reply With QuoteReply With Quote