![]() |
|
#1
|
|||
|
|||
![]() Quote:
Dept = { FORMDROPDOWN } {IF{REF Dropdown1 \* MERGEFORMAT}= "HR" "001"} When the number, in this case 001, is generated by the IF condition, how do you use that number in a calculation/formula? The "001" has no bookmark to use in another formula. What would be the reference? I tried just using the same formula and adding the calculation into it {={IF{REF Dropdown1 \* MERGEFORMAT}= "HR" "001"}*(REF UXOQTY1}} but it doesn't work. In my form I want the N.E.W. (from the selection made in Dropdown UXONomen01) * UXOQTY1 to be calculated and shown in the TOTAL N.E.W. Since the TOTAL N.E.W. textfield relies on bookmarks to do a calculation (right?), I'm guessing it would have to be done outside of the field's properties. I'm not sure how else to explain what I'm trying to do here. Quote:
|
#2
|
||||
|
||||
![]() Quote:
{={IF{REF Dropdown1}= "Finance" 2 {IF{REF Dropdown1}= "HR" 1 0}}*5} where 5 is whatever you want to multiply the selected item's value by. However, that's really no different than: {IF{REF Dropdown1}= "HR" 5}{IF{REF Dropdown1}= "Finance" 10} I suggest you take a look at my Microsoft Word Field Maths Tutorial, available at: http://windowssecrets.com/forums/sho...Maths-Tutorial and: http://www.gmayor.com/downloads.htm#Third_party
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
![]() Quote:
When I am in ALT-F9 view and putting in the code/formula it doesn't always "activate". Is there something else I should be doing? When I go back to normal view the formula is sometimes written out as it is rather than being "invisible". Forgive my terminology... I'm still learning to speak code. ![]() I'm still struggling the get numbers from a dropdown condition to multiply with a FORMTEXT field number. I've tried various ways explained in the tutorial. Again, I'm sure I'm either doing it wrong or assuming one thing works with another when it doesn't. |
#4
|
|||
|
|||
![]() Quote:
I tried using the table cell address that contains the output, but I'm guessing that's not an option either. |
![]() |
Tags |
calculating values, expanding table, form fields |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Macro to keep formatted form fields after mail merge or replace text with formatted form fields | jer85 | Word VBA | 2 | 04-05-2015 10:00 PM |
![]() |
step10 | Word | 18 | 11-12-2013 02:27 PM |
Enable editing in expanding fields | marweste | Word | 11 | 10-21-2013 07:41 AM |
How to prevent Tables from expanding | HappyFingers | Word | 1 | 11-29-2010 01:54 PM |
Calculating Form Fields in Microsoft Word | wubba80 | Word | 1 | 06-25-2010 12:42 AM |