Getting to Know VBA
New Member
- Joined
- Dec 20, 2013
- Messages
- 29
Hi, I am seeking to create a formula that multiples columns B and C and applies the appropriate currency exchange (refer to second table). The result should be the sum total of all rows, being $24.29.
<tbody>
</tbody>
<tbody>
</tbody>
As an example row 3 should calculate as follows: ($500*-10%)*0.88.
Your assistance is greatly appreciated.
A | B | C | |
1 | FX | Unit Price | Open Interest |
2 | AUD | $100 | 0.0% |
3 | SGD | $500 | -10.0% |
4 | GBP | $400 | 5.6% |
5 | AUD | $650 | 4.2% |
<tbody>
</tbody>
6 | Rate | FX |
7 | 1.00 | AUD |
8 | 1.83 | GBP |
9 | 0.88 | SGD |
10 | 1.12 | USD |
<tbody>
</tbody>
As an example row 3 should calculate as follows: ($500*-10%)*0.88.
Your assistance is greatly appreciated.