#1
|
|||
|
|||
Calculate Field from Drop Down Results in Word for Mac 2011
Hello,
For Word for Mac version 2011: I have 5 dropdown lists (bookmark "DD1" to "DD5", in which I have marked "calculate on exit") with numerical values in consecutive columns ("C1" to "C5") in a table. I want for the final column "C6" to be the sum all of these values. In C6 I am inserting a formula field and trying to use the following : - "= REF DD1 + REF DD2" - "= DD1 + DD2" - "{= {REF DD1}+{REF DD2}} - "= {REF DD1}+{REF DD2}" - "= {DD1}+{DD2}" And none of these are working. Either there are syntax errors or it says that the references don't exist in the table.... HOWEVER, if I use a REF field instead of a formula field and just reference "REF DD1", I get the actual value that has been selected in the dropdown. So, obviously the bookmark does work. Can you help me to find the proper way to go about this? Furthermore, if it is possible, I would like for my dropdown list to display percentages rather than a simple number (i.e. "5%", rather than just "5".) Kind regards, Alix |
#2
|
||||
|
||||
A formula field (not a form field) coded as {={REF DD1}+{REF DD2}} should work just fine.
Note: The field brace pairs (i.e. '{ }') for the field are all created in the document itself (via Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thanks Paul,
However, I don't exactly understand exactly how to go about this. So the steps as I understand them should go as follows (?): 1) Insert–>Field... 2)Categories: (All) 3) Field Names: = (Formula) 4)Field codes: = I am not sure exactly what to do here. When I type Cmd-F9 in this "=" field nothing happens. Same goes for if I try in a text field, or when I just type in a non-field, normal way. Cmd-F9 is not giving me anything. Do you know what I am doing wrong? Thanks |
#4
|
|||
|
|||
Quote:
However, I don't exactly understand exactly how to go about this. So the steps as I understand them should go as follows (?): 1) Insert–>Field... 2)Categories: (All) 3) Field Names: = (Formula) 4)Field codes: = I am not sure exactly what to do here. When I type Cmd-F9 in this "=" field nothing happens. Same goes for if I try in a text field, or when I just type in a non-field, normal way. Cmd-F9 is not giving me anything. Do you know what I am doing wrong? Thanks |
#5
|
||||
|
||||
No, you don't use Insert>Field - you create the fields in the body of the document, via Cmd-F9.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#6
|
|||
|
|||
Do I have to have something enabled/disabled in order to make Cmd-F9 function in this way? (Because this exact combination doesn't make anything at all happen for me.)
|
#7
|
||||
|
||||
Pressing Cmd-F9 with the document active should create a pair of field braces at the insertion point. See attached. You should be able to copy the fields from the attachment & paste them into your document.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#8
|
|||
|
|||
Quote:
1) "If you are using a MacBook, to use a function key, you must press the fn key (the lower left key on the keyboard) at the same time", so it is not just Cmd-F9, but Cmd-fn-F9. Which produces the braces at insertion point, in which I can just type. 2) The Insert > Field... *does* work, but I have to do this several times, in effect, nesting each field... one of which is the REF field, which I do each time for each dropdown. Thanks!!! |
#9
|
||||
|
||||
Quote:
Cross-posted at: http://answers.microsoft.com/en-us/m...5-1666df268100 For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mac Word 2011 field help | mstephens | Word | 0 | 01-21-2013 12:03 PM |
Word Form/ActiveX drop down menu/value in a different field | AMackenzieFFCU | Word VBA | 1 | 01-14-2013 07:48 AM |
Calculate date in word field | edwedw | Mail Merge | 3 | 11-30-2011 02:10 PM |
calculate average depending on drop-down values | virencm | Word | 0 | 08-06-2010 06:10 PM |
Using Field Codes to Calculate 5 years from a Date | vandy | Word | 1 | 09-23-2009 11:32 AM |