[program-l] Re: Excell
- From: "Corbett, James" <James.Corbett@xxxxxxxxxxxxx>
- To: <program-l@xxxxxxxxxxxxx>
- Date: Tue, 17 Mar 2009 09:41:07 -0400
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:
