Adding Multiplied Cells in Word 2003 Table

[Lenny]

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

 

[Beth Melton]

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]

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]

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]

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