I'm trying to write a weighted average cost of debt report.
This is very easy to calculate in excel using:
sumproduct(a1:a15,b1:b15)/c15 or as per example below
I have the Values and multiplying factor coming in on the details lines and have used a simple formula (which I will call Weighted...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.