#1   Report Post  
Posted to microsoft.public.word.tables
tphillips tphillips is offline
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.word.tables
macropod macropod is offline
external usenet poster
 
Posts: 1,002
Default 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   Report Post  
Posted to microsoft.public.word.tables
tphillips tphillips is offline
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.word.tables
macropod macropod is offline
external usenet poster
 
Posts: 1,002
Default 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   Report Post  
Posted to microsoft.public.word.tables
tphillips tphillips is offline
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.word.tables
macropod macropod is offline
external usenet poster
 
Posts: 1,002
Default 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   Report Post  
Posted to microsoft.public.word.tables
tphillips tphillips is offline
external usenet poster
 
Posts: 5
Default 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.





Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculations in Table peg84 Tables 3 January 21st 07 05:00 PM
Calculations in tables oe New Users 1 April 1st 06 06:22 PM
Calculations in a mergefield. [email protected] Mailmerge 14 March 3rd 06 09:36 PM
Calculations LindaCoedy Tables 1 November 30th 05 10:16 AM
Calculations in a table Tina Tables 2 December 20th 04 03:35 AM


All times are GMT +1. The time now is 05:30 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"