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 |
#10
|
|||
|
|||
MS Word table - problem with conditional formula
Hi Charles,
I had thought of an ASK field, but it only sets a bookmark - the results are hidden unless you use yet another field (REF) to display them. Hence the bookmarked FILLIN field. Cheers "Charles Kenyon" wrote in message ... You might try an ASK field rather than a fill-in. That will let you set the bookmark directly. This makes up for the bookmark's fragility. You can find an ASK and FILL-IN field tutorial at http://addbalance.com/word/download.htm. I would suggest adding spaces around the equals sign and quotation marks around the comparison items and around your True result as well. I also added a REF field. {*IF*"{*REF*CellB2*}"*=*"X"*"{*PRODUCT({*EntryFee* },2)\#*#0.00*}"*""*} -- Charles Kenyon Word New User FAQ & Web Directory: http://addbalance.com/word Intermediate User's Guide to Microsoft Word (supplemented version of Microsoft's Legal Users' Guide) http://addbalance.com/usersguide See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome! --------- --------- --------- --------- --------- --------- This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn from my ignorance and your wisdom. "Peterkins via OfficeKB.com" u20492@uwe wrote in message news:5e6d9e84e6a5d@uwe... Hi macropod Thanks for your help, but I am still a bit stuck. I have not had experience with bookmarking before but have tried to follow your instructions. Although I don't quite understand how/why maintaining a book mark can be a pain, I opted for your suggestion to create a FILLIN field and this is what I have entered (again * = space): - {*FILLIN*"Enter*X*if*entering*Men's*Singles"\d**\* *MERGEFORMAT*} (I don't understand the Mergeformat bit but presume it has been put there by Word because this is a main document for a mail merge.) I selected all of the Fillin and using Insert Bookmark named it CellB2. The formula in C2 is now: - {*IF*{*CellB2*}=X*{*PRODUCT({*EntryFee*},2)\#*#0. 00*}""*} I ran a mail merge and after answering the ASK prompts I had an error message "A field calculation error occurred in record " for each record in the source document, and all the sections of the resulting Form Letter had "=X" (without quotes) in C2. I didn't get any prompt to "Enter X if entering Men's Singles" even thought the FILLIN switch was set to \d. Any further ideas please? Regards Peter macropod wrote: Hi Peterkins, Table cell referencing doesn't work with text strings. To refer to a character string in a cell, the character string (not the cell itself) must be individually bookmarked and the bookmark referred to in the reference. So my previous post on this was wrong (Should have read my own tutorial)! So, if you bookmark the text range in cell B2 with something like 'Cell2B' you could use a field coded like: {IF{Cell2B}= X {=EntryFee*2} \# £,0.00} Since maintaining the bookmark in such a field can be a PITA, you might find it easiest to add a FILLIN field to cell B2 and bookmark that. Code the FILLIN field something like: {FILLIN "Enter 'X' if accepted"} -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...ables/200604/1 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to put graphics on envelopes? | Steve Koenig | General Discussion | 20 | September 14th, 2007 04:40 PM |
Converting WordPerfect 12 files to Word 2003 | Curious | New Users | 3 | March 29th, 2006 01:05 AM |
WP merge file to Word | sstires | Tables | 4 | February 14th, 2006 06:26 PM |
How to change merge forms from Word Perfect to Microsoft Word | Charles Kenyon | General Discussion | 1 | December 30th, 2004 03:35 PM |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |