SOLVED

COMBINE MROUND AND ROUNDUP??????

%3CLINGO-SUB%20id%3D%22lingo-sub-3111570%22%20slang%3D%22en-US%22%3ECOMBINE%20MROUND%20AND%20ROUNDUP%3F%3F%3F%3F%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3111570%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20new%20to%20Excel%20and%20am%20self%20taught.%20I%20was%20wondering%20if%20I%20could%20use%20a%20combination%20of%20MROUND%20and%20ROUNDUP%20to%20round%20up%20to%20the%20nearest%20multiple%20of%20250%3F%20Or%20is%20there%20an%20easier%20solution%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3111570%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3111606%22%20slang%3D%22en-US%22%3ERe%3A%20COMBINE%20MROUND%20AND%20ROUNDUP%3F%3F%3F%3F%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3111606%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1296156%22%20target%3D%22_blank%22%3E%40ChrisMiller1980%3C%2FA%3E%26nbsp%3BOr%20perhaps%20something%20like%3A%3C%2FP%3E%3CP%3E%3DROUNDUP(A1%2F250%2C0)*250%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3111863%22%20slang%3D%22en-US%22%3ERe%3A%20COMBINE%20MROUND%20AND%20ROUNDUP%3F%3F%3F%3F%3F%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3111863%22%20slang%3D%22en-US%22%3EThank%20you%20very%20much%2C%20I%20had%20a%20feeling%20that%20I%20was%20overthinking%20this.%20It%20worked%20perfectly.%3C%2FLINGO-BODY%3E
Occasional Contributor

I am new to Excel and am self taught. I was wondering if I could use a combination of MROUND and ROUNDUP to round up to the nearest multiple of 250? Or is there an easier solution?

2 Replies
best response confirmed by ChrisMiller1980 (Occasional Contributor)
Solution

@ChrisMiller1980 Or perhaps something like:

=ROUNDUP(A1/250,0)*250

Thank you very much, I had a feeling that I was overthinking this. It worked perfectly.