Rounding Up to next ...

%3CLINGO-SUB%20id%3D%22lingo-sub-1883440%22%20slang%3D%22en-US%22%3ERounding%20Up%20to%20next%20...%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1883440%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20day%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20taking%20the%20time%20to%20assist%2C%20if%20possible.%3C%2FP%3E%3CP%3EI%20work%20for%20a%20mnf%20company%20and%20we%20see%20based%20on%20square%20meter%20supplied%2C%20but%20we%20also%20round%20up%20to%20next%20.25.%3C%2FP%3E%3CP%3EFor%20eg%20-%200.240%20would%20become%200.250%20and%201.032%20would%20become%201.050%3C%2FP%3E%3CP%3EI%20have%20tried%20to%20use%20the%20MROUND%20function%20but%20it%20seems%20to%20round%20to%20nearest%20and%20not%20the%20next%20.02%20up.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20function%20or%20formula%20i%20can%20use%20to%20make%20this%20work%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3CP%3EJohn%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1883440%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1883613%22%20slang%3D%22en-US%22%3ERe%3A%20Rounding%20Up%20to%20next%20...%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1883613%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F867715%22%20target%3D%22_blank%22%3E%40JohnK1609%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20want%20to%20round%20up%20to%20the%20nearest%20multiple%20of%200.25%2C%20shouldn't%201.032%20become%201.25%3F%3C%2FP%3E%0A%3CP%3EApart%20from%20that%3A%20the%20CEILING%20function%20(or%20in%20recent%20versions%20of%20Excel%20CEILING.MATH)%20will%20do%20what%20you%20want%3A%3C%2FP%3E%0A%3CP%3E%3DCEILING(A1%2C0.25)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Good day

 

Thank you for taking the time to assist, if possible.

I work for a mnf company and we see based on square meter supplied, but we also round up to next .25.

For eg - 0.240 would become 0.250 and 1.032 would become 1.050

I have tried to use the MROUND function but it seems to round to nearest and not the next .02 up.

 

Is there a function or formula i can use to make this work?

 

Thank you.

John

2 Replies

@JohnK1609 

If you want to round up to the nearest multiple of 0.25, shouldn't 1.032 become 1.25?

Apart from that: the CEILING function (or in recent versions of Excel CEILING.MATH) will do what you want:

=CEILING(A1,0.25)

Thank you.
The ceiling.math function works.

I mistyped above ... 0.25 should rather say next multiple of 25 ie 00, 25, 50, or 75

but it seems to work the way you recommended .. thank you very much