How do I set up a weighted percentage formula in Excel?
 

I'm trying to set up a sliding scale weighted percentage formula for a
management company. It would be based on a variable number of vehicles that
are weighted differently. As a vehicle would be added at a certain weighted
percentage how would that change the percentage that each vehicle would pay
into a fixed cost? This formula will be used in Excel. Thank you for any
assistance.

How do I set up a weighted percentage formula in Excel?
 

On Jun 18, 5:22*pm, Diamond75
wrote:
I'm trying to set up a sliding scale weighted percentage formula for a
management company. *It would be based on a variable number of vehicles that
are weighted differently. *As a vehicle would be added at a certain weighted
percentage how would that change the percentage that each vehicle would pay
into a fixed cost? *This formula will be used in Excel. *Thank you for any
assistance.

If I read it right, you just sum the weights and then divide the
weight of each truck by the sum to normalize the values. And the
fraction is the percentage of fixed cost each truck would pay. So say
you have 3 trucks with weights 4, 6 and 9. They sum up to 19 so Truck
1 pays 4/19, Truck 2, 6\19 and Truck 3, 9\19 or 21%, 32% and 47%
respectively. I'm sure you can do the simple calcs. in Excel without
my help.

SteveM