Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 11-09-2017, 01:52 PM
macropod's Avatar
macropod macropod is offline Calculations of dropdowns and formfield averages Windows 7 64bit Calculations of dropdowns and formfield averages Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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

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



Similar Threads
Thread Thread Starter Forum Replies Last Post
excel formula while using dropdowns rjf1127 Excel 12 01-25-2017 10:53 AM
Calculations of dropdowns and formfield averages Insert more than 500 characters on FormField Word by VBA 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
Calculations of dropdowns and formfield averages Formfield calculation Joachim Word 4 03-08-2013 01:56 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:29 PM.


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