[program-l] Re: Excell
- From: gerald.g.weichbrodt@xxxxxx
- To: program-l@xxxxxxxxxxxxx
- Date: Tue, 17 Mar 2009 09:46:05 -0400
=SUM(A3:E3)-3.1415926
might be an example.
Cheers,
Jerry
"Corbett, James" <James.Corbett@xxxxxxxxxxxxx>
Sent by: program-l-bounce@xxxxxxxxxxxxx
03/17/2009 09:41 AM
Please respond to
program-l@xxxxxxxxxxxxx
To
<program-l@xxxxxxxxxxxxx>
cc
Subject
[program-l] Re: Excell
Ah, just about to ask you how that was accomplished?
Jim
-----Original Message-----
From: program-l-bounce@xxxxxxxxxxxxx
[mailto:program-l-bounce@xxxxxxxxxxxxx] On Behalf Of
gerald.g.weichbrodt@xxxxxx
Sent: March 17, 2009 09:38
To: program-l@xxxxxxxxxxxxx
Subject: [program-l] Re: Excell
Oops, I did notice I forgot about subtracting the constant, but I knew the
astute Mr. Corbett would have that in hand.
gerald.g.weichbrodt@xxxxxx
Sent by: program-l-bounce@xxxxxxxxxxxxx
03/17/2009 09:33 AM
Please respond to
program-l@xxxxxxxxxxxxx
To
program-l@xxxxxxxxxxxxx
cc
Subject
[program-l] Re: Excell
You talking something like:
=SUM(A3:E3)
being placed in cell G3? That's all it really amounts to. Go to G3 and
type in the above at that location. Youcan hit F2 while sitting in a cell
to edit the formula behind the cell. Even the dollar sign ($) stuff you
may remember from 1-2-3 for making cell coordinates absolute rather than
relative still works in Excel.
Regards,
Jerry
"Corbett, James" <James.Corbett@xxxxxxxxxxxxx>
Sent by: program-l-bounce@xxxxxxxxxxxxx
03/17/2009 08:51 AM
Please respond to
program-l@xxxxxxxxxxxxx
To
<program-l@xxxxxxxxxxxxx>
cc
Subject
[program-l] Excell
Way back when the earth was still green I used Lotus 123.... Now I need to
create a spreadsheet in Excel 2003.
Essentially I need to sum a group of numbers, e.g. a3 thru e3 and then in
g3 the sum must be subtracted by a constant value....
On top of that as I add a new row the function in g3 must be applied to
the new row in this case g4....
Like I said I've never had to use Excel so any pointers would be most
appreciated.
Jim
James M. Corbett
A / Technical Specialist
GST/HST Micros | Micros de la TPS/TVH
GST/HST Redesign Division | Division de la restructuration de la TPS/TVH
Revenue and Accounting Systems Directorate (RASD) | Direction des Systèmes
de revenu et de comptabilité (DSRC)
Information Technology Branch (ITB) | Direction générale de l'informatique
(DGI)
Canada Revenue Agency | Agence du revenue du Canada
(613) 941-1338
"...Is a hippopotamus a hippopotamus, or just a really cool Opotamus?"
** To leave the list, click on the immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** program-l-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** program-l-request@xxxxxxxxxxxxx with the Subject:- faq
** To leave the list, click on the immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=unsubscribe]
** If this link doesn't work then send a message to:
** program-l-request@xxxxxxxxxxxxx
** and in the Subject line type
** unsubscribe
** For other list commands such as vacation mode, click on the
** immediately-following link:-
** [mailto:program-l-request@xxxxxxxxxxxxx?subject=faq]
** or send a message, to
** program-l-request@xxxxxxxxxxxxx with the Subject:- faq
Other related posts:
