Rounding Formula

**accelerator** · 08-23-2012, 04:05 PM

Hi All,

If I have a number, for example 61, is it possible somehow in excel to round it up to 65? So if I have 61, it will be 65 also? and 64 would round to 65?

Thanks for the help....

**daddylonglegs** · 08-23-2012, 04:06 PM

If you want to round up to the nearest 5 then assuming your original number is in A1 try this formula in B1

=CEILING(A1,5)

**Ace_XL** · 08-23-2012, 04:07 PM

=CEILING(A1,5)
would roundup to the nearest multiple of 5

**accelerator** · 08-23-2012, 04:14 PM

Thanks a bunch for that, it worked!

**Cutter** · 08-23-2012, 08:24 PM

@ accelerator

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.