How do I get MROUND to only round up to the next multiple.

G

gmac

I do not wish to get a lower number when rounding to a miltpile of it. I
need to combing the MROUND and ROUNDUP.
 
H

Harlan Grove

gmac said:
I do not wish to get a lower number when rounding to a miltpile of it.
I need to combing the MROUND and ROUNDUP.
Click to expand...

Don't use MROUND. Instead of

=MROUND(x,n)

use

=ROUNDUP(x/n,0)*n
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

rounding a number up to a certain ending digit 6
Round up to next .5 5
Round Function 5
Round Up and Round Down Time 2
Round Up by a factor not by a digit [MROUNDUP(number,multiple)] 8
MRound 8
Inserting MROUND into existing data 1
MROUND error showing 7

Top