Re: Excell can't add

From: Chris R. Lee (chrislee.fedupwithspm_at_freesurf.fr)
Date: 03/01/04 

Date: Mon, 1 Mar 2004 22:23:24 +0100

Thanks.

Unfortunately, this is the sort of quick workaround, shortcut or fancy
trick that computer programming textbooks tell you not to use. Perfectly all
right though for a bit of office software that won't last much longer than
the present version of your favorite spread***.

Of course an explicit function that does the same thing would be more
traceable, but you can't have everything. To reply to another suggestion in
this thread, I'm not competent enough to decide what would be the minimal
command set that would allow you to do most things you want in an
environment that has to be be fully validated.

Regards

"RagDyeR" <ragdyer@cutoutmsn.com> a écrit dans le message de news:
#C7Fm6l$DHA.2012@TK2MSFTNGP11.phx.gbl...
> This will take you to a great many discussions on the unary (--) !
>
> http://tinyurl.com/qvyp
>
> --
>
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
> "Chris R. Lee" <chrislee.fedupwithspm@freesurf.fr> wrote in message
> news:1078002661.2833.0@lotis.uk.clara.net...
> This NG is great, but it's frustrating because you keep discovering things
> that you can't find in Help.
>
> If you look for help on "--", it asks you to reformulate your question;
what
> does "--Range" do?
>
> Concerning the can't add problem, data imported from other "regions" or
> applications can cause trouble because they may have a different decimal
> separator to yours... because after 1000+ years nobody, not even BG, has
> thought of designating a unique symbol for this.
>
> Regards
>
>
> "Aladin Akyurek" <akyurek@xs4all.nl> a écrit dans le message de news:
> 4040d9b4$0$560$e4fe514c@news.xs4all.nl...
> > Always check a
> >
> > =SUM(Range)
> >
> > with
> >
> > =SUMPRODUCT(--Range)
> >
> > When you get a difference between the outcomes or the SumProduct formula
> > ends up in an error value, you have to check Range for text-formatted
> > numbers.
> >
> > "Vickie" <Liskeygh@aol.com> wrote in message
> > news:0ecb01c3fe22$4fdf8e20$a601280a@phx.gbl...
> > > Often excell does not recognize contents of cell as a
> > > number, so when you use sum it does not add these cells
> > > in. I have tried to use the format comand to make
> > > recognize the cell as a number but it doesen't help. I
> > > have learned to format the cells to be added with 4
> > > zeros. This showes me which cells it isn't adding
> > > because it does not add the zero's to the "bad cells".
> > > As I use this extensivly in my work it is a pain not to
> > > be able to trust the answer it gives you.
> >
> >
>
>
>