| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| roundup by 16s | Excel Worksheet Functions | |||
| RoundUp help! | New Users to Excel | |||
| how to use roundup | Excel Discussion (Misc queries) | |||
| Trying To Roundup only if more than zero | Excel Discussion (Misc queries) | |||
| ROUNDUP | Excel Discussion (Misc queries) | |||
Linear Mode
