![]() |
#2
|
||||
|
||||
![]()
The main problem you'll have trying to do this in Word is that Word's table referencing formulae don't recognise text. Consequently, they can't test for 'High', 'Medium', or 'Low'. If your drop down box is a formfield dropdown in a document with forms protection applied, though (but not a content control dropdown), this is not an impediment. Assuming you are working with a formfield dropdown, the field code to do the calculation in Word is:
{IF{REF Dropdown1}= "High" {=B3/(1+B3*0.2^2)} {IF{REF Dropdown1}= "Medium" {=B3/(1+B3*0.1^2)} {IF{REF Dropdown1}= "Low" {=B3/(1+B3*0.05^2)} "FALSE"}}} where Dropdown1 is the formfield dropdown's internal bookmark name and you set it's 'calculate on exit' property. Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message. Nor is it practicable to add them via any of the standard Word dialogues. The spaces represented in the field construction are all required.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Microsoft office 2010 professional plus 64 bit launching issues | kmg | Office | 1 | 11-16-2013 05:56 AM |
Help with IF statement in word 2010 | Mad | Word | 2 | 04-06-2013 06:31 AM |
Combining Multiple Word Documents Heading/Figure Issues Word 2007 | grantgibson45 | Word | 1 | 09-10-2012 11:00 PM |
![]() |
hbforsyth | Word | 9 | 11-14-2011 04:26 PM |
Issues with synchronization log causing send/receive issues | WinSock64 | Outlook | 0 | 01-11-2011 11:29 AM |