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?

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

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]

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