Forum Discussion
ChrisMiller1980
Feb 03, 2022Copper Contributor
COMBINE MROUND AND ROUNDUP??????
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?
- Feb 03, 2022
ChrisMiller1980 Or perhaps something like:
=ROUNDUP(A1/250,0)*250
Riny_van_Eekelen
Feb 03, 2022Platinum Contributor
ChrisMiller1980 Or perhaps something like:
=ROUNDUP(A1/250,0)*250
ChrisMiller1980
Feb 03, 2022Copper Contributor
Thank you very much, I had a feeling that I was overthinking this. It worked perfectly.