![]() |
#2
|
||||
|
||||
![]()
1. Your averaging formula field has the braces for the REF fields typed. You can't do that. They must be created via Insert|Cross-Reference for the bookmarks concerned, or via Ctrl-F9.
2. You can delete the CPC1 bookmark and field associated with it and simply code your averaging formula field as: {=({REF TS2}+{REF SS2}+{REF SRSA2}+{REF OD15}+{REF Clinical2})/{IF{REF Clinical2}= 0 4 5} \# 0} 3. Your document contains a mix of formfields and content controls. These were not designed to work together in the same document and shouldn't be used that way; inconsistent document behaviour can result. Stick to one or the other.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
excel formula while using dropdowns | rjf1127 | Excel | 12 | 01-25-2017 10:53 AM |
![]() |
Jow | Word VBA | 4 | 09-15-2016 04:06 AM |
Formula that calculates cumulative averages | lonniepoet | Excel | 2 | 02-04-2016 06:31 PM |
Taking Averages with N/A's | lynchbro | Excel | 5 | 01-07-2015 10:42 AM |
![]() |
Joachim | Word | 4 | 03-08-2013 01:56 AM |