rounding up to nearest specified whole number

J

Jim

Is there any formula in Microsoft Excel 2003 that will round a cell UP to a
nearest specified whole number?
I'm trying to get a cell to round up to the nearest 5. MROUND will round to
the NEAREST 5 so if the starting number is a 7, it rounds DOWN with the
result being 5. I want to always round UP so the result would be 10.
Threre is a round up formula but it seems to only apply to decimals, not
whole numbers.
Maybe it simply can't be done?
 
R

Ron Rosenfeld

Is there any formula in Microsoft Excel 2003 that will round a cell UP to a
nearest specified whole number?
I'm trying to get a cell to round up to the nearest 5. MROUND will round to
the NEAREST 5 so if the starting number is a 7, it rounds DOWN with the
result being 5. I want to always round UP so the result would be 10.
Threre is a round up formula but it seems to only apply to decimals, not
whole numbers.
Maybe it simply can't be done?
Click to expand...

=ceiling(a1,5)
=roundup(a1/5,0)*5

And you need to decide what you mean if you want to apply these techniques to
negative numbers.
--ron
 

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

Similar Threads

Round formula 1
Round Down to the nearest multiple 2
Rounding up or down decimals to the nearest 5 2
Round time up to nearest :15 2
Rounding up or down to nearest whole number 1
Average rounded to nearest 0.50 4
round up to nearest 50p 1
Format cell to the nearest 100 4

Top