In Excel, there are two ways of calculating the weighted average with percentages: using the SUM function and using the SUMPRODUCT function. Let us have a look at these 2 methods in detail.

You can use PMT to calculate the interest rate in Excel. However, you also need to use NPER, PV, and FV. A typing formula looks like this: =RATE(nper,pmt,pv,[fv]) where: ...

Adding a running total to a simple Microsoft Excel revenue sheet isn't difficult, but adding a conditional running total will require a bit more effort. Solutions are simpler than you might think.

How to Calculate Percentage Change. Calculating percentage change is one of the most frequently used tasks in Excel. The basic formula is: (New Value / Old Value) – 1.