| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Wanting to sum a colum of numbers and then roundup to the next dol
I'am wanting to write a formula that would sum a colum of numbers and then
round those numbers up or down to the hole dollar. A B 1 22.10 45.76 2 22.35 43.10 3 I would want cell A3 to roundup to 45.00 and cell B3 to rounddown to 48.00. Thanks for any help. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Wanting to sum a colum of numbers and then roundup to the next dol
In A3 for your example:
=CEILING(SUM(A1:A2),1) In B3: =FLOOR(SUM(B1:B2),1) "AL" wrote: I'am wanting to write a formula that would sum a colum of numbers and then round those numbers up or down to the hole dollar. A B 1 22.10 45.76 2 22.35 43.10 3 I would want cell A3 to roundup to 45.00 and cell B3 to rounddown to 48.00. Thanks for any help. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Wanting to sum a colum of numbers and then roundup to the next
Thanks BoniM! That's what I was looking for.
AL "BoniM" wrote: In A3 for your example: =CEILING(SUM(A1:A2),1) In B3: =FLOOR(SUM(B1:B2),1) "AL" wrote: I'am wanting to write a formula that would sum a colum of numbers and then round those numbers up or down to the hole dollar. A B 1 22.10 45.76 2 22.35 43.10 3 I would want cell A3 to roundup to 45.00 and cell B3 to rounddown to 48.00. Thanks for any help. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Wanting to sum a colum of numbers and then roundup to the next
You're welcome, happy to help. Thanks for the feedback!
"AL" wrote: Thanks BoniM! That's what I was looking for. AL "BoniM" wrote: In A3 for your example: =CEILING(SUM(A1:A2),1) In B3: =FLOOR(SUM(B1:B2),1) "AL" wrote: I'am wanting to write a formula that would sum a colum of numbers and then round those numbers up or down to the hole dollar. A B 1 22.10 45.76 2 22.35 43.10 3 I would want cell A3 to roundup to 45.00 and cell B3 to rounddown to 48.00. Thanks for any help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| only numbers in a colum are seen-no cells-no little squares | Excel Discussion (Misc queries) | |||
| ranking a colum of numbers | Excel Worksheet Functions | |||
| total colum using x instesd of numbers what is the formula | Excel Worksheet Functions | |||
| How do I get numbers on a colum to stay as I typed them on an exc. | Excel Discussion (Misc queries) | |||
| how do I put in line numbers in the first colum starting in row A. | Excel Discussion (Misc queries) | |||
Linear Mode
