On Tue, 12 Feb 2008 22:43:48 -0500
Howard wrote:
> Am I dumb or what?(James,your supposed to say here its 'or what' so I
> don`t feel so stupid!)LOL!
>
> I opened a new calc.put 6 in A1,2 in A2,then put =A1+A2,hit return and
> that worked.
>
> I wasn`t hitting return before,I thought it would add by itself.
>
> I knew I was doing something wrong when your demo worked!
>
> Thanks for the help.
>
> Will that also work if I have ,say ten numbers in a row and use the
> 11th cell to add them all together?
Yes, except there is a shortcut for multiple numbers:
1.a Enter your 10 or however many digits in
.b Click in the square you wish the answer
.c Look for the greek letter Sigma on the toolbar "?"
This is the Sum function
Click it
.d Highlight the cells you wish to be added up
.e Tap the [Enter] Key
OR
2.a Follow steps a and b above.
.b Type =SUM(a1:b1)
.c Tap the [Enter] key
SUM is one of the simplest functions in any spreadsheet program. Open
help and do a search on "function" for many more.
>
> How far will the resolution carry out/
> 5 decimals,10,or as far as I make the cell wide?
>
> Also how do I write it to add 10 cells in a row?Or 100 cells.?
>
> Do I have to put all cell numbers inthe equation?
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> 9James your supposed to say its "or what " o i don`t feel so
> stupid!)LOL----- Original Message -----
> From: "James Knott" <[EMAIL PROTECTED]>
> To: <[email protected]>
> Sent: Tuesday, February 12, 2008 9:08 PM
> Subject: Re: [users] I am using version 2.3 of OpenOffice.org. My
> problem is:
>
>
> > Howard wrote:
> > > Ok, the demo works cuz I changed one of the numbers and got the
> > > correct answer.
> > >
> > > But if I open Calc and put two numbers in where do I put the
> =A1-B1,assuming
> > > I have a number in A1 and A2?
> > >
> > >
> >
> > You'd put it in whatever cell you wish to contain the answer.
> >
> >
> > --
> > Use OpenOffice.org <http://www.openoffice.org>
> >
> > -------------------------------------------------------------------
> > -- To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
--
Michael
All shall be well, and all shall be well, and all manner of things shall
be well
- Julian of Norwich 1342 - 1416
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
