|
| 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
October 23rd, 2007, 09:37 PM
posted to microsoft.public.word.tables
|
|||
|
|||
calculations
I am trying to: qty * unit + flat. qty is in A2, unit is in D2, and flat is
in C2. How do I write that formula? I have Word 2000 and have only used it for mail merge letters. Calculations in table is new for me. Thank you. 
|
|
#2
October 23rd, 2007, 10:02 PM
posted to microsoft.public.word.tables
|
|||
|
|||
|
calculations
Hi tphillips
You could use a formula field coded as {=A2*D2+C2}. For more information on how to do calculations in Word, check out my Word Field Maths 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=365442 or http://www.gmayor.com/downloads.htm#Third_party Cheers -- macropod [MVP - Microsoft Word] ------------------------- "tphillips" wrote in message ... I am trying to: qty * unit + flat. qty is in A2, unit is in D2, and flat is in C2. How do I write that formula? I have Word 2000 and have only used it for mail merge letters. Calculations in table is new for me. Thank you.
|
|
#3
October 23rd, 2007, 10:22 PM
posted to microsoft.public.word.tables
|
|||
|
|||
|
calculations
I put in my field {=A2*D2+C2}. Now what?
Can I send the document to you, you put it in (so it works) and send back. I'm just not getting it to work. "macropod" wrote: Hi tphillips You could use a formula field coded as {=A2*D2+C2}. For more information on how to do calculations in Word, check out my Word Field Maths 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=365442 or http://www.gmayor.com/downloads.htm#Third_party Cheers -- macropod [MVP - Microsoft Word] ------------------------- "tphillips" wrote in message ... I am trying to: qty * unit + flat. qty is in A2, unit is in D2, and flat is in C2. How do I write that formula? I have Word 2000 and have only used it for mail merge letters. Calculations in table is new for me. Thank you.
|
|
#4
October 23rd, 2007, 11:46 PM
posted to microsoft.public.word.tables
|
|||
|
|||
|
calculations
Hi tphillips,
Did you use a field, or simply type the string in? You can't do the latter, as the field braces (ie '{ }') must be created in pairs via Ctrl-F9 or Insert|Field. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "tphillips" wrote in message ... I put in my field {=A2*D2+C2}. Now what? Can I send the document to you, you put it in (so it works) and send back. I'm just not getting it to work. "macropod" wrote: Hi tphillips You could use a formula field coded as {=A2*D2+C2}. For more information on how to do calculations in Word, check out my Word Field Maths 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=365442 or http://www.gmayor.com/downloads.htm#Third_party Cheers -- macropod [MVP - Microsoft Word] ------------------------- "tphillips" wrote in message ... I am trying to: qty * unit + flat. qty is in A2, unit is in D2, and flat is in C2. How do I write that formula? I have Word 2000 and have only used it for mail merge letters. Calculations in table is new for me. Thank you.
|
|
#5
October 24th, 2007, 03:12 PM
posted to microsoft.public.word.tables
|
|||
|
|||
|
calculations
I am desperate. I can not get this to work. Is there any one out there that
can fix my document? I will gladly send it to some one. "macropod" wrote: Hi tphillips, Did you use a field, or simply type the string in? You can't do the latter, as the field braces (ie '{ }') must be created in pairs via Ctrl-F9 or Insert|Field. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "tphillips" wrote in message ... I put in my field {=A2*D2+C2}. Now what? Can I send the document to you, you put it in (so it works) and send back. I'm just not getting it to work. "macropod" wrote: Hi tphillips You could use a formula field coded as {=A2*D2+C2}. For more information on how to do calculations in Word, check out my Word Field Maths 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=365442 or http://www.gmayor.com/downloads.htm#Third_party Cheers -- macropod [MVP - Microsoft Word] ------------------------- "tphillips" wrote in message ... I am trying to: qty * unit + flat. qty is in A2, unit is in D2, and flat is in C2. How do I write that formula? I have Word 2000 and have only used it for mail merge letters. Calculations in table is new for me. Thank you.
|
|
#6
October 24th, 2007, 09:45 PM
posted to microsoft.public.word.tables
|
|||
|
|||
|
calculations
Hi tphillips,
I wonder if you're expecting too much from Word's formula fields. They will do the calculation OK but, unlike Excel, they don't automatically update. For that, you need to select the field and press F9, or do something else to trigger the update, like a print preview or printing the document, or using the calculation in a document protected for forms, where the values in A2, D2 and C2 are obtained from formfields whose properties are all set to 'calculate on exit'. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "tphillips" wrote in message ... I am desperate. I can not get this to work. Is there any one out there that can fix my document? I will gladly send it to some one. "macropod" wrote: Hi tphillips, Did you use a field, or simply type the string in? You can't do the latter, as the field braces (ie '{ }') must be created in pairs via Ctrl-F9 or Insert|Field. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "tphillips" wrote in message ... I put in my field {=A2*D2+C2}. Now what? Can I send the document to you, you put it in (so it works) and send back. I'm just not getting it to work. "macropod" wrote: Hi tphillips You could use a formula field coded as {=A2*D2+C2}. For more information on how to do calculations in Word, check out my Word Field Maths 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=365442 or http://www.gmayor.com/downloads.htm#Third_party Cheers -- macropod [MVP - Microsoft Word] ------------------------- "tphillips" wrote in message ... I am trying to: qty * unit + flat. qty is in A2, unit is in D2, and flat is in C2. How do I write that formula? I have Word 2000 and have only used it for mail merge letters. Calculations in table is new for me. Thank you.
|
|
#7
October 25th, 2007, 06:10 PM
posted to microsoft.public.word.tables
|
|||
|
|||
|
calculations
I finally got my table with calculations to work using the post:
Subject: Using Formulas in a Table 1/24/2007 2:00 AM PST Thank you for your help. "macropod" wrote: Hi tphillips, I wonder if you're expecting too much from Word's formula fields. They will do the calculation OK but, unlike Excel, they don't automatically update. For that, you need to select the field and press F9, or do something else to trigger the update, like a print preview or printing the document, or using the calculation in a document protected for forms, where the values in A2, D2 and C2 are obtained from formfields whose properties are all set to 'calculate on exit'. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "tphillips" wrote in message ... I am desperate. I can not get this to work. Is there any one out there that can fix my document? I will gladly send it to some one. "macropod" wrote: Hi tphillips, Did you use a field, or simply type the string in? You can't do the latter, as the field braces (ie '{ }') must be created in pairs via Ctrl-F9 or Insert|Field. Cheers -- macropod [MVP - Microsoft Word] ------------------------- "tphillips" wrote in message ... I put in my field {=A2*D2+C2}. Now what? Can I send the document to you, you put it in (so it works) and send back. I'm just not getting it to work. "macropod" wrote: Hi tphillips You could use a formula field coded as {=A2*D2+C2}. For more information on how to do calculations in Word, check out my Word Field Maths 'tutorial', at: http://www.wopr.com/cgi-bin/w3t/show...?Number=365442 or http://www.gmayor.com/downloads.htm#Third_party Cheers -- macropod [MVP - Microsoft Word] ------------------------- "tphillips" wrote in message ... I am trying to: qty * unit + flat. qty is in A2, unit is in D2, and flat is in C2. How do I write that formula? I have Word 2000 and have only used it for mail merge letters. Calculations in table is new for me. Thank you.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
