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.

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

Top