VBABeginner
New member
- Joined
- Aug 5, 2015
- Messages
- 1
- Reaction score
- 0
- Points
- 0
| A | B | C | D | E | F |
| Carat | Sub Amount ($) | Fixed Rate 1.6 | Fixed 350 ($) | FX Rate | Total Amount ($) |
| 0.96 | 8645.76 | 1.6 | 350 | 1.33 | |
| 0.97 | 7874.46 | 1.6 | 350 | 1.33 |
Question 1:
Formula should be - Carat x Sub Amount x 1.6 + SGD $350 x 1.33
What should my formula be based on the above under Total Amount?
Question 2:
How do I insert this into Excel Macro?
Your advice is much appreciated. Pls. help.
