Hi Patti,
In your scenario with cell E2 being where the payment heading is placed, F2
for the deposit heading and G2 for the balance heading, your formula for
current month balance could go in G3. Let's say you have 200 rows for each
month. Your amounts start in row 4. The formula for current balance for
the given month to go in to cell G3 might be something like the following:
=sum(f4:f300)-sum(e4:e300)
In cell H3 you would show the balance in effect at the end of the previous
month. You could go to G3 for the previous month and copy the cell's
contents and then paste that to H3 in the current month's worksheet. This
would probably be as quick a way as any other to do it. Use CTRL-pageup to
move to previous worksheet, use CTRL-G to bring up the go to box, type in G3
and press enter. Use CTRL-C to copy the cell's contents. Use CTRL-page
down to move back to current month's sheet, use CTRL-G to bring up the go to
box, type in h3 and press enter key. Paste the contents of the clipboard in
that cell.
To write the formula in H3 of the current month instead of pasting the
amount, you need to use the name of the worksheet and the cell or cell range
from the previous month. Let's say the current month is April. In h3 of
April you might write:
=March!g3 (note the exclamation mark between the worksheet name being
referenced and the cell or cell range).
If there is a space, number or other character other than alphabet letters,
then the name of the worksheet should be in quotations. For example, you
might write in H3 of April:
="march 2008"!G3 (Note the exclamation mark after the closing quote and
before the cell reference.
Feel free to write me off list if I can offer any more help.
Take care.
Brian Lee
[email protected]
Message -----
From: "Patti" <[email protected]>
To: <[email protected]>
Sent: Friday, January 16, 2009 12:51 PM
Subject: Re: [JAWS-Users] Excel 2003 formulas
Thanks for getting back to me.
What I'm doing is making a check book with the columns
A. check number, B cancel, C. date, D who to, E. payment, F deposit, G.
balance, and cell h3 is the forward balance from last month.
All this is in row 2, and the first row to write in should be row 4.
I don't know how to write the formula in a blank excel table.
Thanks again
Patti
block quote
Hi Patty;
Think I can help but am a little confused about your terminology. payment
to is a text field?Balance is the new balance?
Where are you deducting the payment to ?
regards
Scott
--------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG -
http://www.avg.com
Version: 8.0.176 / Virus Database: 270.10.8/1898 - Release Date: 1/16/2009
3:09 PM
block quote end
Patti,
Would be glad to help, but are not sure what you're trying to do. E.g.,
what is balance forward? What is pay to? If you can describe in words
what you are trying to do, I can easily translate that into a formula for
you.
Darrin
Darrin Porter
Senior Technical Engineer
United Ocean Services, L.L.C.
1300 East 8th Avenue
Tampa, Florida 33605
(813) 209-4247 (office)(813) 744-0011 (cellular phone)
(813) 242-4849 (fax)
[email protected]
-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Patti
Sent: Friday, January 16, 2009 1:49 PM
To: Jaws
Subject: [JAWS-Users] Excel 2003 formulas
Hey Gang,
I'm trying to figure out how to write a formula with excel 2003, but
every
time I do, I'm doing something wrong.
Here is what I want.
In cell h3 should be the balance forward, e4 should be payment to, f4
should
be deposits, and g4 is the balance.
Can some one tell me the steps on writing a formula?
I'm using Jaws 8, windows XP, and excel 2003.
Thanks for any help you can give me.
Patti
"They say it is better to be poor and happy than rich and miserable, but
how
about a compromise
like moderately rich and just moody?"
Princess Diana
Visit the JAWS Users List home page at:
http://www.jaws-users.com
Visit the Blind Computing home page at:
http://www.blind-computing.com
Address for the list archives:
http://www.mail-archive.com/[email protected]
To post to this group, send email to
[email protected]
To unsubscribe from this group, send an email to
[email protected]
For help from Mailman with your account Put the word help in the subject
or body of a blank message to:
[email protected]
Use the following address in order to contact the management team
[email protected]
If you wish to join the Blind Computing list send a blank email to the
following address:
[email protected]
Attention: This email and any accompanying attachments constitute
confidential and/or legally privileged information. If you have received
this email communication in error, please notify the sender immediately
and delete the message and any attachments from your system.
Visit the JAWS Users List home page at:
http://www.jaws-users.com
Visit the Blind Computing home page at:
http://www.blind-computing.com
Address for the list archives:
http://www.mail-archive.com/[email protected]
To post to this group, send email to
[email protected]
To unsubscribe from this group, send an email to
[email protected]
For help from Mailman with your account Put the word help in the subject
or body of a blank message to:
[email protected]
Use the following address in order to contact the management team
[email protected]
If you wish to join the Blind Computing list send a blank email to the
following address:
[email protected]
--------------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.176 / Virus Database: 270.10.8/1898 - Release Date: 1/16/2009
3:09 PM
Visit the JAWS Users List home page at:
http://www.jaws-users.com
Visit the Blind Computing home page at:
http://www.blind-computing.com
Address for the list archives:
http://www.mail-archive.com/[email protected]
To post to this group, send email to
[email protected]
To unsubscribe from this group, send an email to
[email protected]
For help from Mailman with your account Put the word help in the subject
or body of a blank message to:
[email protected]
Use the following address in order to contact the management team
[email protected]
If you wish to join the Blind Computing list send a blank email to the
following address:
[email protected]
Visit the JAWS Users List home page at:
http://www.jaws-users.com
Visit the Blind Computing home page at:
http://www.blind-computing.com
Address for the list archives:
http://www.mail-archive.com/[email protected]
To post to this group, send email to
[email protected]
To unsubscribe from this group, send an email to
[email protected]
For help from Mailman with your account Put the word help in the subject or
body of a blank message to:
[email protected]
Use the following address in order to contact the management team
[email protected]
If you wish to join the Blind Computing list send a blank email to the
following address:
[email protected]
