Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-04-2020, 08:02 PM
Guessed's Avatar
Guessed Guessed is offline Calculation in form field doubles the amount Windows 10 Calculation in form field doubles the amount Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,185
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

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



Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculation in form field doubles the amount Simple Calculation with a Merge Field shawn.low@cox.net Mail Merge 3 01-01-2020 03:49 AM
Calculation in form field doubles the amount 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
Calculation in form field doubles the amount Form field calculation returning 2x correct result Jschueller Word 1 08-20-2013 01:51 PM
Calculation in form field doubles the amount Large amount of text as a form field. JustK Word 2 11-15-2011 11:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:37 AM.


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