Prev: Works outing '09
Next: new to macs...a newsreader q..
From: Sara on 23 Oct 2009 11:35
In article <7kdtn4F39g591U1(a)mid.individual.net>,
Chris Ridd <chrisridd(a)mac.com> wrote:

> On 2009-10-23 15:38:57 +0100, Chris Ridd <chrisridd(a)mac.com> said:
>
> > On 2009-10-23 15:22:26 +0100, Sara <saramerriman(a)blueyonder.co.uk> said:
> >> Is there a way to make Excel just add up the numbers as displayed?
>
> Another way: Set Preferences > Calculation > Precision as displayed.
> Apparently that throws away any non-displayed precision in the whole
> worksheet and you cannot get it back, so it looks kind of risky.

I'll play with this too, but your other suggestion sounds more like the
sort of thing I'm looking for.

Thanks a million.

--
Sara

Cuddler of rats, cats and husband
From: Dorian Gray on 26 Oct 2009 14:42
In article <David.Sankey-430203.15495423102009(a)south.jnrs.ja.net>,
David Sankey <David.Sankey(a)stfc.ac.uk> wrote:

> In article <saramerriman-544A7C.15222623102009(a)news.individual.net>,
> Sara <saramerriman(a)blueyonder.co.uk> wrote:
>
> > F'rinstance, a column of figures like these:
> >
> > 10.234
> > 10.0111114446
> > 15.244
> >
> > Total: 35.48911144
> >
> > Will display as:
> >
> > 10.23
> > 10.01
> > 15.24
> >
> > Total: 35.49
> >
> > Which leads to customers (quite rightly) complaining that their bills
> > don't add up.
> >
> > Is there a way to make Excel just add up the numbers as displayed?

There is no need to irreversibly change the precision to as displayed,
nor is there a need to create a new column, nor is there a need to SUM
each cell in a separate ROUND() command like
=SUM(ROUND(A1,2),ROUND(A2,2),ROUND(A3,2))
which might be fine for a handful of cells, but does not scale to a
large range of cells.

Actually all you need to do is type:
=SUM(ROUND(A1:A3,2))
and then without leaving the cell press command-enter. This enters it
as an array formula, which is exactly what you need.

Cheers.
From: Dorian Gray on 26 Oct 2009 14:47
In article <D.Gray-B621C7.18425626102009(a)nntp-serv.cam.ac.uk>,
Dorian Gray <D.Gray(a)picture.invalid> wrote:

> Actually all you need to do is type:
> =SUM(ROUND(A1:A3,2))
> and then without leaving the cell press command-enter.

command-return also works, and is what is usually written.

> This enters it
> as an array formula, which is exactly what you need.
>
> Cheers.
From: Sara on 2 Nov 2009 11:55
In article <D.Gray-B621C7.18425626102009(a)nntp-serv.cam.ac.uk>,
Dorian Gray <D.Gray(a)picture.invalid> wrote:

> In article <David.Sankey-430203.15495423102009(a)south.jnrs.ja.net>,
> David Sankey <David.Sankey(a)stfc.ac.uk> wrote:
>
> > In article <saramerriman-544A7C.15222623102009(a)news.individual.net>,
> > Sara <saramerriman(a)blueyonder.co.uk> wrote:
> >
> > > F'rinstance, a column of figures like these:
> > >
> > > 10.234
> > > 10.0111114446
> > > 15.244
> > >
> > > Total: 35.48911144
> > >
> > > Will display as:
> > >
> > > 10.23
> > > 10.01
> > > 15.24
> > >
> > > Total: 35.49
> > >
> > > Which leads to customers (quite rightly) complaining that their bills
> > > don't add up.
> > >
> > > Is there a way to make Excel just add up the numbers as displayed?
>
> There is no need to irreversibly change the precision to as displayed,
> nor is there a need to create a new column, nor is there a need to SUM
> each cell in a separate ROUND() command like
> =SUM(ROUND(A1,2),ROUND(A2,2),ROUND(A3,2))
> which might be fine for a handful of cells, but does not scale to a
> large range of cells.
>
> Actually all you need to do is type:
> =SUM(ROUND(A1:A3,2))
> and then without leaving the cell press command-enter. This enters it
> as an array formula, which is exactly what you need.
>
Just got back to this thread after another nightmare session with
falling over mail servers.

That looks like exactly the thing I wanted. Thanks a million.

--
Sara

Cuddler of rats, cats and husband
From: Dorian Gray on 2 Nov 2009 13:49
In article <saramerriman-DCD420.16555602112009(a)news.individual.net>,
Sara <saramerriman(a)blueyonder.co.uk> wrote:

> That looks like exactly the thing I wanted. Thanks a million.

Oh, hi, glad it looks the ticket - glad you're seeing these posts (I was
wondering).
First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: Works outing '09
Next: new to macs...a newsreader q..