Results 1 to 2 of 2

Thread: How to come up with the formula for this scenario?

  1. #1

    How to come up with the formula for this scenario?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.

  2. #2
    Super Moderator p45cal's Avatar
    Join Date
    Dec 2012
    Posts
    1,833
    Articles
    0
    Excel Version
    365
    What should the answers be for each row in your example?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •