Hi All,
I'm trying to write a formula such that, if the first column is a B, i'd multiple -1 to the counter amount. if the first column is S i'd multiple -1 to the amount column. i'd think a if.. then .. vba should work but i can't figure out whats next. could anyone please help?
<colgroup><col><col><col span="2"><col></colgroup><tbody>
</tbody>
I'm trying to write a formula such that, if the first column is a B, i'd multiple -1 to the counter amount. if the first column is S i'd multiple -1 to the amount column. i'd think a if.. then .. vba should work but i can't figure out whats next. could anyone please help?
| B/S | Amount | Currency | Price | Counter Amount |
| B | 30 000.00 | AUD | 0.74501 | 22 350.30 |
| B | 1 000.00 | AUD | 0.74451 | 744.51 |
| S | 500 | AUD | 0.74421 | 372.1 |
| B | 1 000.00 | AUD | 0.74411 | 744.11 |
| B | 1 000 000.00 | AUD | 0.74375 | 743 750.00 |
| S | 1 000 000.00 | AUD | 0.74375 | 743 750.00 |
| S | 1 000 000.00 | AUD | 0.74374 | 743 740.00 |
| B | 1 000 000.00 | AUD | 0.74374 | 743 740.00 |
| B | 1 000 000.00 | AUD | 0.74375 | 743 750.00 |
<colgroup><col><col><col span="2"><col></colgroup><tbody>
</tbody>
