| 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. |
| 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) | |||
Threaded Mode
