Learn how to calculate Weighted Average in Excel with percentages using the SUM function and the SUMPRODUCT function.

Calculate the weighted average of interest rates in Microsoft Excel to compute the most accurate average interest rate among a group of lenders who received different rates.

If you wish to calculate the GPA or Grade Point Average in Microsoft Excel or other Excel editor, you can use this formula.

Excel 2013 provides the DATE and XIRR functions, which derive the final annual interest rate from a series of payments on known dates.