#1
|
|||
|
|||
Calculations of dropdowns and formfield averages
I'm in quite a pickle here. I've done research and figured out some issues on my own, but this one has stumped me. I am doing a performance review and I am trying to get the average of multiple fields that contain calculations. Each field is either a dropdown formfield with a number or a bookmarked cell with a formula inside calculating an average. I need to create a formula that averages the five main parts (5th part is optional). My work around to this was creating an if/else statement that would show either a 4 or 5 iF part 5 has a selection other than "0" in it to work on the overall average. Here is my equation (not working): {=({REF TS2}+{REF SS2}+{REF SRSA2}+{REF OD15}+{REF Clinical2})/{REF CPC1} \# 0} OD15 is the cell with the average calculation that had the bookmark inserted CPC1 is the if/else statement to make the average calculation easier. Thank you for the help in advance. |
#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] |
#3
|
|||
|
|||
You are a god among men and women. Thank you so much for your help. I was scratching my head cause I figured you can just type in the formulas...LOL
I really appreciate your help. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
excel formula while using dropdowns | rjf1127 | Excel | 12 | 01-25-2017 10:53 AM |
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 |
Formfield calculation | Joachim | Word | 4 | 03-08-2013 01:56 AM |