Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
can I add a column and roundup with 1 function?
I need to add a column of numbers (about 25) and round the total. How do I
do that in one cell (function)? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
can I add a column and roundup with 1 function?
=ROUND(SUM(A1:A25);2)
HTH -- AP "Sheila" a écrit dans le message de ... I need to add a column of numbers (about 25) and round the total. How do I do that in one cell (function)? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
can I add a column and roundup with 1 function?
Oooops:
=ROUND(SUM(A1:A25),2) (I'm used to french localized syntax) -- AP "Sheila" a écrit dans le message de ... I need to add a column of numbers (about 25) and round the total. How do I do that in one cell (function)? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Roundup to the nearest number that is divisible by 3 | Excel Worksheet Functions | |||
How do I ROUNDUP a Column of cells on a worksheet template? | Excel Worksheet Functions |