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
|