Calc | Type | ExpRatio | Holding% | FundCost | Mixed |
$36,233 | equity | 0.69% | 9.35% | $250 | |
$29,026 | mixed | 0.60% | 7.49% | $174 | 0.38 |
$41,933 | fixed | 0.97% | 10.82% | $407 | |
$32,045 | equity | 0.77% | 8.27% | $247 | |
$9,934 | mixed | 0.63% | 2.56% | $63 | 0.51 |
$8,761 | equity | 1.31% | 2.26% | $115 | |
$7,429 | mixed | 1.04% | 1.92% | $77 | 0.29 |
$42,075 | equity | 0.90% | 10.86% | $379 | |
$19,146 | equity | 1.13% | 4.94% | $216 | |
$22,023 | equity | 0.96% | 5.68% | $211 | |
$14,574 | fixed | 0.93% | 3.76% | $136 | |
$28,024 | equity | 0.62% | 7.23% | $174 | |
$24,800 | mixed | 0.56% | 6.40% | $139 | 0.24 |
$12,119 | fixed | 0.62% | 3.13% | $75 | |
$36,001 | equity | 0.75% | 9.29% | $270 | |
$9,527 | equity | 1.07% | 2.46% | $102 | |
$0 | fixed | 0.99% | 0.00% | $0 | |
$13,764 | equity | 1.38% | 3.55% | $190 |
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Given the above data, I want to ADD UP (and place in a new cell): IF "Type" = "mixed", Then I want to multiply the ratio in the "mixed" column Times the amount in the Calc column.