Consulting

Results 1 to 2 of 2

Thread: Problem with formula

  1. #1

    Problem with formula

    Hi,
    I have this excel sheet where I have 3 qty and 3 rates and an weighted average,my question is If I have 2 qty by what rate should I multiply both the qty to arrive at the total.
    Attached Files Attached Files

  2. #2
    VBAX Expert shrivallabha's Avatar
    Joined
    Jan 2010
    Location
    Mumbai
    Posts
    750
    Location
    Hi,

    Your calculation formula in merged cell B11 differs with what is written here.

    See attached file. Is this what you are after?
    Attached Files Attached Files
    Regards,
    --------------------------------------------------------------------------------------------------------
    Shrivallabha
    --------------------------------------------------------------------------------------------------------
    Using Excel 2016 in Home / 2010 in Office
    --------------------------------------------------------------------------------------------------------

Posting Permissions

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