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.