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