rounding up to nearest specified whole number
 

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?

rounding up to nearest specified whole number
 

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