[TJ]

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.

[macropod]

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.

[challa prabhu]

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.

[Lenny]

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.

[Suzanne S. Barnhill]

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.