SOLVED

COMBINE MROUND AND ROUNDUP??????

Copper 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 (Copper 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.
1 best response

Accepted Solutions
best response confirmed by ChrisMiller1980 (Copper Contributor)
Solution

@ChrisMiller1980 Or perhaps something like:

=ROUNDUP(A1/250,0)*250

View solution in original post