rounding up to nearest specified whole number Jim 12/31/2008 3:41:02 PM 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?

Re: rounding up to nearest specified whole number Ron Rosenfeld <ronrosenfeld[ at ]nospam.org> 12/31/2008 4:31:37 PM On Wed, 31 Dec 2008 07:41:02 -0800, Jim <Jim[ at ]discussions.microsoft.com> wrote: [Quoted Text] >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