A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Tables
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Adding Multiplied Cells in Word 2003 Table



 
 
Thread Tools Display Modes
  #1  
Old February 26th, 2008, 12:14 AM posted to microsoft.public.word.tables
Lenny
external usenet poster
 
Posts: 112
Default Adding Multiplied Cells in Word 2003 Table

I am trying to do the following in a protected Word form template...
Add the following: A9*100+B9*200+C9*500+D9*1,000+E9*5,000+F9*10,000 then
divide the total (/) by 2

How is this written out as a formula? I've tried it several ways and come up
with errors.... what am I doing wrong?
{=A9*100; +B9*200; etc
{=SUM(A9*100)+(B9*200)etc

Lenny
  #2  
Old February 26th, 2008, 12:40 AM posted to microsoft.public.word.tables
Beth Melton
external usenet poster
 
Posts: 2,566
Default Adding Multiplied Cells in Word 2003 Table

You need to use implement the Order of Operations and you need to use
numbers only, no commas or semicolons. Your formula should look something
like:

{=((A9*100)+(B9*200)+....)/2}

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
https://mvp.support.microsoft.com/profile/Melton

What is a Microsoft MVP? http://mvp.support.microsoft.com/gp/mvpfaqs

"Lenny" wrote in message
news
I am trying to do the following in a protected Word form template...
Add the following: A9*100+B9*200+C9*500+D9*1,000+E9*5,000+F9*10,000 then
divide the total (/) by 2

How is this written out as a formula? I've tried it several ways and come
up
with errors.... what am I doing wrong?
{=A9*100; +B9*200; etc
{=SUM(A9*100)+(B9*200)etc

Lenny



  #3  
Old February 26th, 2008, 01:24 AM posted to microsoft.public.word.tables
Lenny
external usenet poster
 
Posts: 112
Default Adding Multiplied Cells in Word 2003 Table

Beth: thank you for your response, but still a problem.

should there be a double parentheses at the end to match the double at the
beginning of the formula. I notices you did not add spaces between the
parentheses and the +, does this make a difference in the formula? I rewrote
the formula per your sample and it is not adding correctly, nor does it seem
to be diving the total in half.

Maybe a little more explanation..... the table I'm setting up is
representative of the denominations for savings bonds. The table is set up
for a 'numeric' entry below each of the denominations (i.e., 100, 200, 500,
1,000, 5,000 and 10,000 dollars). Entries would typically be single numbers
1, 2, 3 etc. There is a cell that totals the number of entries and then a
'Total Purchase Price' of all of the selected denominations. The formula I
was trying to use multiplied the number of each denomination by its dollar
value, totaled everything, then divided half since the purchase price is half
(50%) of the face value of the bond.

The formula is not giving me the correct number. If I enter (1) in each of
the denominations, the total should be 16,800 but is totaling 16,300. I
checked this by deleting the division portion of the equation.... is there
something else that I'm missing in this type of equation??? Do I need to do
a 'hidden' cell to actually create a virtual total then add that and divide
by 2? Regards, Lenny

"Beth Melton" wrote:

You need to use implement the Order of Operations and you need to use
numbers only, no commas or semicolons. Your formula should look something
like:

{=((A9*100)+(B9*200)+....)/2}

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
https://mvp.support.microsoft.com/profile/Melton

What is a Microsoft MVP? http://mvp.support.microsoft.com/gp/mvpfaqs

"Lenny" wrote in message
news
I am trying to do the following in a protected Word form template...
Add the following: A9*100+B9*200+C9*500+D9*1,000+E9*5,000+F9*10,000 then
divide the total (/) by 2

How is this written out as a formula? I've tried it several ways and come
up
with errors.... what am I doing wrong?
{=A9*100; +B9*200; etc
{=SUM(A9*100)+(B9*200)etc

Lenny




  #4  
Old February 26th, 2008, 04:09 AM posted to microsoft.public.word.tables
Beth Melton
external usenet poster
 
Posts: 2,566
Default Adding Multiplied Cells in Word 2003 Table

I'm not sure where your formula is off, the sample I gave you will do what
you want. Perhaps some explanation of how you need to calculate the
expression will help.

To recap the Order of Operations:
- Calculations in parentheses
- Calculate Powers/Exponents
- Multiplication and Division (left to right)
- Addition and Subtraction (left to right)

Each multiplication formula needs to be inside of parentheses, such as
(C9*500). Then each of those formulas need to be added to together:
{=(A9*100)+(B9*200)+(C9*500)+(D9*1000)+(E9*5000)+( F9*10000)}

Lastly, you want to calculate the entire addition/multiplication expression
prior to dividing by 2. You don't need to do this in two steps, one formula
is fine. In order to make sure this occurs you need to surround the entire
expression with parentheses and then divide by 2:
{=((A9*100)+(B9*200)+(C9*500)+(D9*1000)+(E9*5000)+ (F9*10000))/2}

Also, you don't need spaces between the operators.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
https://mvp.support.microsoft.com/profile/Melton

What is a Microsoft MVP? http://mvp.support.microsoft.com/gp/mvpfaqs

"Lenny" wrote in message
...
Beth: thank you for your response, but still a problem.

should there be a double parentheses at the end to match the double at the
beginning of the formula. I notices you did not add spaces between the
parentheses and the +, does this make a difference in the formula? I
rewrote
the formula per your sample and it is not adding correctly, nor does it
seem
to be diving the total in half.

Maybe a little more explanation..... the table I'm setting up is
representative of the denominations for savings bonds. The table is set
up
for a 'numeric' entry below each of the denominations (i.e., 100, 200,
500,
1,000, 5,000 and 10,000 dollars). Entries would typically be single
numbers
1, 2, 3 etc. There is a cell that totals the number of entries and then a
'Total Purchase Price' of all of the selected denominations. The formula
I
was trying to use multiplied the number of each denomination by its dollar
value, totaled everything, then divided half since the purchase price is
half
(50%) of the face value of the bond.

The formula is not giving me the correct number. If I enter (1) in each
of
the denominations, the total should be 16,800 but is totaling 16,300. I
checked this by deleting the division portion of the equation.... is there
something else that I'm missing in this type of equation??? Do I need to
do
a 'hidden' cell to actually create a virtual total then add that and
divide
by 2? Regards, Lenny

"Beth Melton" wrote:

You need to use implement the Order of Operations and you need to use
numbers only, no commas or semicolons. Your formula should look something
like:

{=((A9*100)+(B9*200)+....)/2}

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
https://mvp.support.microsoft.com/profile/Melton

What is a Microsoft MVP? http://mvp.support.microsoft.com/gp/mvpfaqs

"Lenny" wrote in message
news
I am trying to do the following in a protected Word form template...
Add the following: A9*100+B9*200+C9*500+D9*1,000+E9*5,000+F9*10,000
then
divide the total (/) by 2

How is this written out as a formula? I've tried it several ways and
come
up
with errors.... what am I doing wrong?
{=A9*100; +B9*200; etc
{=SUM(A9*100)+(B9*200)etc

Lenny






  #5  
Old February 26th, 2008, 04:55 PM posted to microsoft.public.word.tables
Lenny
external usenet poster
 
Posts: 112
Default Adding Multiplied Cells in Word 2003 Table

Beth: It worked! There was a problem on my end with the formula and when I
added the closing parenthesis, it worked. Many thanks. Also thank you for
taking the time to explain the Order of Operations - that will help more than
anything else to understand how to produce a formula that works.

Lenny

"Beth Melton" wrote:

I'm not sure where your formula is off, the sample I gave you will do what
you want. Perhaps some explanation of how you need to calculate the
expression will help.

To recap the Order of Operations:
- Calculations in parentheses
- Calculate Powers/Exponents
- Multiplication and Division (left to right)
- Addition and Subtraction (left to right)

Each multiplication formula needs to be inside of parentheses, such as
(C9*500). Then each of those formulas need to be added to together:
{=(A9*100)+(B9*200)+(C9*500)+(D9*1000)+(E9*5000)+( F9*10000)}

Lastly, you want to calculate the entire addition/multiplication expression
prior to dividing by 2. You don't need to do this in two steps, one formula
is fine. In order to make sure this occurs you need to surround the entire
expression with parentheses and then divide by 2:
{=((A9*100)+(B9*200)+(C9*500)+(D9*1000)+(E9*5000)+ (F9*10000))/2}

Also, you don't need spaces between the operators.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
https://mvp.support.microsoft.com/profile/Melton

What is a Microsoft MVP? http://mvp.support.microsoft.com/gp/mvpfaqs

"Lenny" wrote in message
...
Beth: thank you for your response, but still a problem.

should there be a double parentheses at the end to match the double at the
beginning of the formula. I notices you did not add spaces between the
parentheses and the +, does this make a difference in the formula? I
rewrote
the formula per your sample and it is not adding correctly, nor does it
seem
to be diving the total in half.

Maybe a little more explanation..... the table I'm setting up is
representative of the denominations for savings bonds. The table is set
up
for a 'numeric' entry below each of the denominations (i.e., 100, 200,
500,
1,000, 5,000 and 10,000 dollars). Entries would typically be single
numbers
1, 2, 3 etc. There is a cell that totals the number of entries and then a
'Total Purchase Price' of all of the selected denominations. The formula
I
was trying to use multiplied the number of each denomination by its dollar
value, totaled everything, then divided half since the purchase price is
half
(50%) of the face value of the bond.

The formula is not giving me the correct number. If I enter (1) in each
of
the denominations, the total should be 16,800 but is totaling 16,300. I
checked this by deleting the division portion of the equation.... is there
something else that I'm missing in this type of equation??? Do I need to
do
a 'hidden' cell to actually create a virtual total then add that and
divide
by 2? Regards, Lenny

"Beth Melton" wrote:

You need to use implement the Order of Operations and you need to use
numbers only, no commas or semicolons. Your formula should look something
like:

{=((A9*100)+(B9*200)+....)/2}

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP
https://mvp.support.microsoft.com/profile/Melton

What is a Microsoft MVP? http://mvp.support.microsoft.com/gp/mvpfaqs

"Lenny" wrote in message
news I am trying to do the following in a protected Word form template...
Add the following: A9*100+B9*200+C9*500+D9*1,000+E9*5,000+F9*10,000
then
divide the total (/) by 2

How is this written out as a formula? I've tried it several ways and
come
up
with errors.... what am I doing wrong?
{=A9*100; +B9*200; etc
{=SUM(A9*100)+(B9*200)etc

Lenny






 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:30 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.