My question is regarding supplier scorecards in Excel. Example) There are three vendors, three factors (ie. Quality, Performance, Cost) and their respective weighting (ie. 30%, 40%, and 30%). The table contains the score (value x weighting) and provides a ranking of which supplier is considered “best”. Is there a macro or built in tool within Excel that would calculate how much a weighting would need to change or a change in the combination of weights that would need to change in order for the supplier rank to change from say 1 to 2?