I'm glad I could help......Thanks for the feedback.


***********
Regards,
Ron

XL2002, WinXP


"Chev320" wrote:

Thank You it worked!!!

"Ron Coderre" wrote:

Try something like this:

=CEILING(SUM(K32:K33),5)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Chev320" wrote:

I am trying to round up to the nearest 5 in a formula, and i am having no
luck.. the formula is this "=ROUNDUP(SUM(K32:K33),0)"
I would appreciate any help you could give me.

Thanks