I need to add a column of numbers (about 25) and round the total. How do I
do that in one cell (function)?
I need to add a column of numbers (about 25) and round the total. How do I
do that in one cell (function)?
=ROUND(SUM(A1:A25);2)
HTH
--
AP
"Sheila" <Sheila@discussions.microsoft.com> a écrit dans le message de
news:62216980-FC8C-418A-A4FA-2CDC727D719C@microsoft.com...
> I need to add a column of numbers (about 25) and round the total. How do
I
> do that in one cell (function)?
Oooops:
=ROUND(SUM(A1:A25),2)
(I'm used to french localized syntax)
--
AP
"Sheila" <Sheila@discussions.microsoft.com> a écrit dans le message de
news:62216980-FC8C-418A-A4FA-2CDC727D719C@microsoft.com...
> I need to add a column of numbers (about 25) and round the total. How do
I
> do that in one cell (function)?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks