+ Reply to Thread
Results 1 to 4 of 4

To calculate amount based on %

  1. #1
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    158

    To calculate amount based on %

    Dear Friends,

    PFA the file.

    I need to calculate amount in col K.
    is there any formula which can calculate the amount since the data is huge and calculating the amount manually is time consuming.

    Please assist.
    Attached Files Attached Files

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    2010 & 2016
    Posts
    4,694

    Re: To calculate amount based on %

    On the proviso the sample data is truly representative of the real data, i.e. the SOL ID column really does contain 1 Total, 2 Total etc. then the below formula in K9 and copied down could work.
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    BSB
    Please show appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  3. #3
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    158

    Re: To calculate amount based on %

    Wow....
    You made my day,,,,
    Thanks a ton.

  4. #4
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    2010 & 2016
    Posts
    4,694

    Re: To calculate amount based on %

    Happy to help

    BSB

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1