rounding up to nearest specified whole number

  • Thread starter Thread starter Jim
  • Start date Start date
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?
 
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 time up to nearest :15 2
Round Down to the nearest multiple 2
Average rounded to nearest 0.50 4
round up to nearest 50p 1
Rounding up or down decimals to the nearest 5 2
Round Number to Nearest 50 3
Round time to nearest 15 minutes in decimal format 4

Back
Top