ExcelBanter - RoundUp

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - RoundUp (https://www.excelbanter.com/excel-discussion-misc-queries/138028-roundup.html)

Chev320

RoundUp

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

RoundUp

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

David Biddulph[_2_]

RoundUp

=CEILING(SUM(K32:K33),5)
--
David Biddulph

"Chev320" wrote in message
...
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

Chev320

RoundUp

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

Ron Coderre

RoundUp

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

All times are GMT +1. The time now is 08:59 PM.