Could someone please help me with a formula
If I have
100,000 at 7%
and
15,000 at 11%
what would be the rate of the total debt 115,000
thanks
Josh
Could someone please help me with a formula
If I have
100,000 at 7%
and
15,000 at 11%
what would be the rate of the total debt 115,000
thanks
Josh
try thisOriginally Posted by Josh_123456
=(100000*.07)+(15000*.11)
starguy
Tahir Aziz
PAKISTAN
https://www.facebook.com/businessexcel
__________________
Forum Rules (read before you post)
Links to the world of Excel
I tried an online one and this was the result
100,000 at 7 %
and
25,000 at 9 %
equals a blended rate of 125,000 at 7.4 %
So I am trying to figure how to build this into a formula.
Thanks for trying
Josh
Assuming A1 has the first amount, B1 the first rate and A2 has the second amount, and B2 has the second rate, this formula will give you the blended rate:
=((A1*B1)+(A2*B2))/SUM(A1:A2)
Thank you,
it works great
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks