I have bought a bought a bond in different face value e.g. 1000 lacs, 280 lacs, 220 lacs, 180 lacs etc at different rate e.g. 102.10, 102.20, 103.10, 104.50. In this case how could I find the avereage cost for my total purchase ?
2007-07-27 18:32:24 · 4 answers · asked by vishalrs96 1 in Science & Mathematics ➔ Mathematics
I think you're looking for a weighted average price. If lacs are in column A, and rates in column B, this formula will calculate the weighted average:
=SUM(A2:A100*B2:B100) / SUM(A2:A100)
You input this using Ctrl-Shift-Enter (rather than just Enter), since it's an array formula.
.
2007-07-28 01:19:30 · answer #1 · answered by aladou 5 · 0⤊ 0⤋
Price Formula Excel
2016-10-31 21:54:48 · answer #2 · answered by ? 4 · 0⤊ 0⤋
There are different avarages. Lets assume you want average per dollar of face value. So the average must be the total cost divided by the total face value.
So you need to sum two columns (one for face value and one for cost)..if thats what you mean by price
2007-07-27 18:44:59 · answer #3 · answered by Anonymous · 0⤊ 0⤋
Go to an empty cell and type
"=average("
then click each cell or range of cells you want to average, then type
")"
and press Enter.
2007-07-27 18:36:33 · answer #4 · answered by lithiumdeuteride 7 · 0⤊ 0⤋