+ 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
    205

    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
    365
    Posts
    5,503

    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

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

    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
    365
    Posts
    5,503

    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)

Similar Threads

  1. calculate amount charged based on various rates
    By imran999 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-14-2018, 03:48 AM
  2. Replies: 5
    Last Post: 06-17-2016, 10:22 AM
  3. [SOLVED] Formula to Calculate amount based on the start and end date
    By arpanpanchal in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-21-2016, 08:03 PM
  4. Calculate a capped deals amount based on client
    By Beautiful2 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-11-2013, 03:49 PM
  5. Calculate a capped deals amount based on client
    By Beautiful2 in forum Excel General
    Replies: 3
    Last Post: 05-11-2013, 01:33 PM
  6. [SOLVED] SUMPRODUCT to calculate amount based on different criteria
    By pjlau in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-30-2012, 05:41 AM
  7. [SOLVED] How can I calculate amount of time left based on amount spent?
    By KLD in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-23-2006, 11:25 AM

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