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)?

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)?

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)?