Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Possible to calculate from a cell?


also, is it required to end formatting switches with "\*
MERGEFORMAT"


No it isn't.


or is that something Word puts in unnecessarily?):


Yes, although I suspect MS thinks inserting it results in a better
experience on average for most users and they may be right.

--
Peter Jamieson
http://tips.pjmsn.me.uk

"JAnderson" wrote in message
...
That makes sense, thank you. Now, what if each Merge field is itself
determined by an if statement? Here's a simplified example ignoring
formatting for now (also, is it required to end formatting switches with
"\*
MERGEFORMAT" or is that something Word puts in unnecessarily?):

Subtotal: {if {MERGEFIELD A} = "Widget" "300.00" "150.00"}
Tax: {if {MERGEFIELD B} = "Ohio" "20.00" "0.00"}
Shipping: {if {MERGEFIELD C} = "Ohio" "20.00" "0.00"}

TOTAL: ????? (Normally I would just nest all 3 of the above IF statements,
but there must be a better way).

Any ideas?

"Doug Robbins - Word MVP" wrote:

Use the formula

{ = { MERGEFIELD A } + { MERGEFIELD B } + { MERGEFIELD C } }

You must use Ctrl+F9 to insert each pair of field delimiters { }, and you
may also want to add a formatted switch.

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"JAnderson" wrote in message
news
I'm very familiar with Excel, but not very much with Word and its Merge
fields.

I want to use a calculated value in several places, based on the
contents
of
merge fields. Example:

Subtotal: (Merge field A)
Tax: (Merge field B)
Shipping: (Merge field C)
TOTAL: (SUM of all 3 fields)

So, the question is whether I can have a cell where I can sum all 3
fields,
and whether I can reference that "TOTAL" field in another few places in
the
document (rather than recalculating each time).

Thanks for any suggestions!







 
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
How do I lock a cell in a table so no one can type in the cell? Jen0678 Tables 2 April 11th 07 10:50 PM
Cell referencing in table formulas - just ONE adjacent cell Ngan Tables 5 May 20th 06 02:10 AM
How do I move from cell to cell iin a table column in Word 2003? MOSwannabe Tables 4 January 26th 06 10:17 PM
cell marker missing - can not type text into cell Mary Smith 360 Tables 1 December 20th 05 05:04 AM
How do I auto copy data from cell in a word table to another cell. Nev New Users 1 February 4th 05 08:51 PM


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

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"