RoundUp

[Chev320]

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

 

[Ron Coderre]

Try something like this:

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

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

XL2002, WinXP

 

[David Biddulph]

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

 

[Chev320]

Thank You it worked!!!

Try something like this:

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

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

XL2002, WinXP

 

[Ron Coderre]

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


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

XL2002, WinXP