Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-11-2015, 04:23 PM
acerie acerie is offline Calculate Field from Drop Down Results in Word for Mac 2011 Mac OS X Calculate Field from Drop Down Results in Word for Mac 2011 Office for Mac 2011
Novice
Calculate Field from Drop Down Results in Word for Mac 2011
 
Join Date: Nov 2015
Posts: 5
acerie is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 11-11-2015, 04:27 PM
macropod's Avatar
macropod macropod is offline Calculate Field from Drop Down Results in Word for Mac 2011 Windows 7 64bit Calculate Field from Drop Down Results in Word for Mac 2011 Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #3  
Old 11-11-2015, 06:05 PM
acerie acerie is offline Calculate Field from Drop Down Results in Word for Mac 2011 Mac OS X Calculate Field from Drop Down Results in Word for Mac 2011 Office for Mac 2011
Novice
Calculate Field from Drop Down Results in Word for Mac 2011
 
Join Date: Nov 2015
Posts: 5
acerie is on a distinguished road
Default

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
Reply With Quote
  #4  
Old 11-11-2015, 06:10 PM
acerie acerie is offline Calculate Field from Drop Down Results in Word for Mac 2011 Mac OS X Calculate Field from Drop Down Results in Word for Mac 2011 Office for Mac 2011
Novice
Calculate Field from Drop Down Results in Word for Mac 2011
 
Join Date: Nov 2015
Posts: 5
acerie is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
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.
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
Reply With Quote
  #5  
Old 11-11-2015, 06:14 PM
macropod's Avatar
macropod macropod is offline Calculate Field from Drop Down Results in Word for Mac 2011 Windows 7 64bit Calculate Field from Drop Down Results in Word for Mac 2011 Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #6  
Old 11-11-2015, 06:17 PM
acerie acerie is offline Calculate Field from Drop Down Results in Word for Mac 2011 Mac OS X Calculate Field from Drop Down Results in Word for Mac 2011 Office for Mac 2011
Novice
Calculate Field from Drop Down Results in Word for Mac 2011
 
Join Date: Nov 2015
Posts: 5
acerie is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
No, you don't use Insert>Field - you create the fields in the body of the document, via Cmd-F9.
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.)
Reply With Quote
  #7  
Old 11-11-2015, 06:26 PM
macropod's Avatar
macropod macropod is offline Calculate Field from Drop Down Results in Word for Mac 2011 Windows 7 64bit Calculate Field from Drop Down Results in Word for Mac 2011 Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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.
Attached Files
File Type: docx Fields.docx (18.4 KB, 16 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #8  
Old 11-11-2015, 06:42 PM
acerie acerie is offline Calculate Field from Drop Down Results in Word for Mac 2011 Mac OS X Calculate Field from Drop Down Results in Word for Mac 2011 Office for Mac 2011
Novice
Calculate Field from Drop Down Results in Word for Mac 2011
 
Join Date: Nov 2015
Posts: 5
acerie is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
No, you don't use Insert>Field - you create the fields in the body of the document, via Cmd-F9.
Alright, I figured it out. There are two ways of going about this:

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!!!
Reply With Quote
  #9  
Old 11-11-2015, 06:49 PM
macropod's Avatar
macropod macropod is offline Calculate Field from Drop Down Results in Word for Mac 2011 Windows 7 64bit Calculate Field from Drop Down Results in Word for Mac 2011 Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by acerie View Post
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.
Yes, you can do it via Insert > Field, but that's terribly inefficient compared to simply pressing Cmd-F9 (or Cmd-fn-F9) three times to create them. You also wouldn't want to be using Insert > Field for the complex field coding examples depicted in my Mailmerge Tips & Tricks thread (https://www.msofficeforums.com/mail-merge/) or in the Word field math & date tutorials referred to in that link.

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]
Reply With Quote
Reply

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 Field from Drop Down Results in Word for Mac 2011 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
Calculate Field from Drop Down Results in Word for Mac 2011 Using Field Codes to Calculate 5 years from a Date vandy Word 1 09-23-2009 11:32 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:50 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft