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?

On Wed, 31 Dec 2008 07:41:02 -0800, Jim wrote:

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?

=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