![]() |
|
#1
|
||||
|
||||
![]()
Three issues:
1. Your formula fields lack the required space between 'REF' and 'Dropdown' (e.g. you have 'REFDropdown1' instead of 'REF Dropdown1'); 2. You have employed typed braces (i.e. { }) instead of inserting field braces via Ctrl-F9, as a result of which you've also failed to maintained the required pairing (e.g. {= { REFDropdown1} +{REFDropdown2} +/#0} } instead of {= { REF Dropdown1} +{REF Dropdown2} \# 0}); and 3. You've messed up the numeric picture switch (e.g. +/#0 instead of \# 0)
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#2
|
|||
|
|||
![]()
Oh, I didn't realize that Ctrl + F9 go around each "REF Dropdown" expression. Now instead of Syntax Error, I'm getting: !Undefined Bookmark, CHOOSE. I've attached undated document.
jfb |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
artofanime | Word Tables | 1 | 10-15-2019 08:40 PM |
![]() |
acerie | Word | 8 | 11-11-2015 06:49 PM |
Pivot Table - How to calculate from Grand Total field | LoriD | Excel | 0 | 06-15-2015 07:05 PM |
calculate average depending on drop-down values | virencm | Word | 0 | 08-06-2010 06:10 PM |
Word - Calculate and paste values from Excel sheet | Augf87 | Word | 1 | 07-06-2009 10:26 AM |