Results 1 to 5 of 5

Split Amount Based on condition

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-13-2013
    Location
    Saudi Arabia
    MS-Off Ver
    2010, 2013
    Posts
    192

    Question Split Amount Based on condition

    Hello again,

    I am looking for help in a formula which will split amount based on conditions as mentioned below.

    - Split amount by first amount in C16 cell
    Example in this case: 2,814,761.01
    Starting from 1,000,000.00 then 1,000,000.00 and finally this amount 814,761.01


    - Discounts will be applied until the maximum spited amount
    Example in this case:
    1,000,000.00 * 0% as first amount
    1,000,000.00 * 1% as 2nd amount
    and finally 814,761.01 * 2% as final amount.

    Note: the amount and percentages are dynamic and keep changing.

    copy of ample file is attached for your reference.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Converting Amount based on condition(s)
    By shon in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-21-2018, 11:26 AM
  2. [SOLVED] Need to find a negative amount and match it to the positve amount based on Acct# and Date
    By sbrandhorst in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-07-2016, 07:49 PM
  3. Split an amount evenly with condition
    By JustM3 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-04-2014, 09:43 AM
  4. Split the equal amount acoss months based on start and end date
    By Ktahilramani in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-07-2014, 11:18 PM
  5. Macro to split based on condition
    By somusas in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2013, 07:42 AM
  6. split text files stored in some location to multiple files based on a condition
    By GIRISH_KH in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-01-2013, 11:32 AM
  7. How to COUNTIF the amount based 2 condition
    By pjlau in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-03-2012, 07:03 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