#1
|
|||
|
|||
Calculation in form field doubles the amount
I’m trying to create a user form to book catering for functions. I’ve got drop down lists for menu items - all working fine.
I’ve then inserted cost fields (currency) for starter course, fish course, main course and dessert In the next section I have a Total cost per head field which adds the above field contents - all ok Next I have a field for number of people, then a field for extras I now need a field to calculate #costperhead multiplied by#numberofpeople + #extras. I typed the calculation as =(costperhead*numberofpeople)+extras but the result is double the amount it should be. Can anyone advise me how to write the calculation to return the correct value please? |
#2
|
||||
|
||||
You could always divide by two
=((costperhead*numberofpeople)+extras)/2 Or perhaps load the problem document so we can see how your calculation is actually created. Is it possible that you are tracking revisions and the extra numbers are coming from tracked revisions?
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#3
|
||||
|
||||
This is a long-standing, documented, bug with formfields. The simple remedy is to use a formula field instead of a calculating formfield for the problematic calculation.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#4
|
|||
|
|||
It works!
many thanks for your help - Dividing by 2 works! However my brain can't get around the fact that it just seems wrong to have to do this. Ive uploaded a copy of the main parts of the document (I think - I'm new to this, can't you tell
I thought about using formulas instead of form fields for the total as suggested but not sure of the syntax to use Testmenu for forum.docx |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Simple Calculation with a Merge Field | shawn.low@cox.net | Mail Merge | 3 | 01-01-2020 03:49 AM |
Macro to autofill a form field ONLY if the form field is blank upon entry | Pindar | Word VBA | 2 | 01-12-2017 05:03 PM |
Form Controls - Calculation Options | Perk | Word | 17 | 09-18-2015 06:55 AM |
Form field calculation returning 2x correct result | Jschueller | Word | 1 | 08-20-2013 01:51 PM |
Large amount of text as a form field. | JustK | Word | 2 | 11-15-2011 11:17 AM |