Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
TJ TJ is offline
external usenet poster
 
Posts: 32
Default Using Formulas in a Table

I'm using one of the Invoice Templates. I need to know how to set up the
formula so that it will automatically take the quantity and multiply it by
the unit price. I've tried several ways, and i can't get it to work. Can
anyone PLEASE help me??

Thanks.
  #2   Report Post  
Posted to microsoft.public.word.tables
macropod macropod is offline
external usenet poster
 
Posts: 1,002
Default Using Formulas in a Table

Hi TJ

Unlike Excel, Word tables don't automatically recalculate. You can get
calculations in a document to update automatically when they're in a document
protected for forms and:
1) at least one of the inputs for the calculation is gained from a formfield;
and
2) the formfield's properties are set to 'calculate on exit'.

The calculation fields can be created by pressing Ctrl-F9 to create the field
(denoted by a pair of field braces (ie '{ }')) and:
3) if the calculation only references cells within the table, inputting the
formula along the lines of '=A1*B1' between the field braces; or
4) if the calculation references fields outside the table, inputting the
formula along the lines of '=BkMrk1*BkMrk2' between the field braces, where
'BkMrk1' and 'BkMrk2' are the formfield bookmark names.
You can also use '=BkMrk1*A1' if the calculation references cells within the
table and fields outside the table.

For more information on tables and calculations in Word, check out my Word
Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=365442

Cheers

--
macropod
[MVP - Microsoft Word]


"TJ" wrote in message
...
| I'm using one of the Invoice Templates. I need to know how to set up the
| formula so that it will automatically take the quantity and multiply it by
| the unit price. I've tried several ways, and i can't get it to work. Can
| anyone PLEASE help me??
|
| Thanks.


  #3   Report Post  
Posted to microsoft.public.word.tables
challa prabhu challa prabhu is offline
external usenet poster
 
Posts: 77
Default Using Formulas in a Table

If you use mathematical function, you have to view Word tables similar to
Microsoft Excel speadsheet.
For example, The column headings of Excel is A,B,C and so on, will have to
considered the simlar way when you work in Word Table. And the way you
refernce the cells in Excel will be the same in Word too.

Assuming that you have three columns, and you want the product of column 1
and two in column three. you will enter the fomula this way:

1. Place the insertion point in Column three.
2. Press Ctrl+9 to create the braces{}.
3. Enter the formula inside the brace by preceding with the symbol "="
The formula you enter should like this {=A1*B1}. You can brackets to specify
the order of caluclation.
4. Press F9 to recalculate the product details to display the current value.

Challa Prabhu

"TJ" wrote:

I'm using one of the Invoice Templates. I need to know how to set up the
formula so that it will automatically take the quantity and multiply it by
the unit price. I've tried several ways, and i can't get it to work. Can
anyone PLEASE help me??

Thanks.

  #4   Report Post  
Posted to microsoft.public.word.tables
Lenny Lenny is offline
external usenet poster
 
Posts: 74
Default Using Formulas in a Table

Macropod: something that might help new users....
Unlike Excel which can have absolute, relative and mixed cell references,
Word table cells use absolute cell references, when merged, they take on the
cell reference to the left. There is a very handy tool that comes as an
'add-in' with Word called Table Cell Helper. Click inside any single or
merged cell and it provides a pop-up with the cell location (A13, BB1 etc)
within the table as well as the number of columns and rows in the table.
Very handy when identifying cells to include in calculations. It can be added
to your Normal template making it available to all Word files. Regards -
Lenny

"macropod" wrote:

Hi TJ

Unlike Excel, Word tables don't automatically recalculate. You can get
calculations in a document to update automatically when they're in a document
protected for forms and:
1) at least one of the inputs for the calculation is gained from a formfield;
and
2) the formfield's properties are set to 'calculate on exit'.

The calculation fields can be created by pressing Ctrl-F9 to create the field
(denoted by a pair of field braces (ie '{ }')) and:
3) if the calculation only references cells within the table, inputting the
formula along the lines of '=A1*B1' between the field braces; or
4) if the calculation references fields outside the table, inputting the
formula along the lines of '=BkMrk1*BkMrk2' between the field braces, where
'BkMrk1' and 'BkMrk2' are the formfield bookmark names.
You can also use '=BkMrk1*A1' if the calculation references cells within the
table and fields outside the table.

For more information on tables and calculations in Word, check out my Word
Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=365442

Cheers

--
macropod
[MVP - Microsoft Word]


"TJ" wrote in message
...
| I'm using one of the Invoice Templates. I need to know how to set up the
| formula so that it will automatically take the quantity and multiply it by
| the unit price. I've tried several ways, and i can't get it to work. Can
| anyone PLEASE help me??
|
| Thanks.



  #5   Report Post  
Posted to microsoft.public.word.tables
Suzanne S. Barnhill Suzanne S. Barnhill is offline
external usenet poster
 
Posts: 33,624
Default Using Formulas in a Table

The TableCellHelper macro is available at
http://word.mvps.org/FAQs/AppErrors/...eIncorrect.htm, but see also
http://gregmaxey.mvps.org/Table_Cell_Data.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Lenny" wrote in message
...
Macropod: something that might help new users....
Unlike Excel which can have absolute, relative and mixed cell references,
Word table cells use absolute cell references, when merged, they take on

the
cell reference to the left. There is a very handy tool that comes as an
'add-in' with Word called Table Cell Helper. Click inside any single or
merged cell and it provides a pop-up with the cell location (A13, BB1 etc)
within the table as well as the number of columns and rows in the table.
Very handy when identifying cells to include in calculations. It can be

added
to your Normal template making it available to all Word files.

Regards -
Lenny

"macropod" wrote:

Hi TJ

Unlike Excel, Word tables don't automatically recalculate. You can get
calculations in a document to update automatically when they're in a

document
protected for forms and:
1) at least one of the inputs for the calculation is gained from a

formfield;
and
2) the formfield's properties are set to 'calculate on exit'.

The calculation fields can be created by pressing Ctrl-F9 to create the

field
(denoted by a pair of field braces (ie '{ }')) and:
3) if the calculation only references cells within the table, inputting

the
formula along the lines of '=A1*B1' between the field braces; or
4) if the calculation references fields outside the table, inputting the
formula along the lines of '=BkMrk1*BkMrk2' between the field braces, wh

ere
'BkMrk1' and 'BkMrk2' are the formfield bookmark names.
You can also use '=BkMrk1*A1' if the calculation references cells within

the
table and fields outside the table.

For more information on tables and calculations in Word, check out my

Word
Field Maths 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=365442

Cheers

--
macropod
[MVP - Microsoft Word]


"TJ" wrote in message
...
| I'm using one of the Invoice Templates. I need to know how to set up

the
| formula so that it will automatically take the quantity and multiply

it by
| the unit price. I've tried several ways, and i can't get it to work.

Can
| anyone PLEASE help me??
|
| Thanks.




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
Headers and Footers in Main Body with Table Breaks NewUser_Sanket Page Layout 11 March 13th 06 09:18 PM
20x20 multiplication table Bob S Tables 2 December 24th 05 02:27 PM
Populate Table from Access MTechG Mailmerge 8 December 16th 05 07:08 PM
Table formulas and references Stephen Glynn New Users 1 November 13th 05 01:45 PM
Row height problem with table in table Stephanie T. Tables 0 November 23rd 04 03:35 PM


All times are GMT +1. The time now is 08:32 AM.

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

About Us

"It's about Microsoft Word"