## how to calculate blended rate in excel?

There are a few different ways to calculate a blended rate in Excel, depending on the data you have available. One way to calculate a blended rate is to take the weighted average of two or more rates. To do this, you first need to calculate the weight for each rate. The weight is simply …