formula

[Sammy]

The final sum/total must remain the same: $100.00.
Working backwards the % of profit has to change so whatever changes are made
to the subtotals, the final cost remains $100.00.

 

[Bernie Deitrick]

Percent Profit is

=(100 - SUM(Costs involved))/SUM(Costs involved)

HTH,
Bernie
MS Excel MVP

 

[Sammy]

would you take a look at this spread sheet?

Percent Profit is

=(100 - SUM(Costs involved))/SUM(Costs involved)

HTH,
Bernie
MS Excel MVP