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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|