View Single Post
 
Old 06-04-2020, 08:02 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
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