+ Reply to Thread
Results 1 to 2 of 2

Distribution payment by sales formulas

  1. 04-05-2018, 11:20 PM #1
    payeekvadder
    payeekvadder is offline
    Registered User
    Join Date
    03-30-2018
    Location
    KUALA LUMPUR, MALAYSIA
    MS-Off Ver
    EXCEL 2010
    Posts
    26

    Distribution payment by sales formulas

    hi all,

    need a favour to formula this distribution
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-06-2018, 01:39 AM #2
    samba_ravi
    samba_ravi is offline
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Distribution payment by sales formulas

    L3=MIN(D3,C3*20%)
    M3=MIN(D3-L3,C3*40%)
    N3=MIN(D3-L3-M3,C3*40%)
    Try this and copy towards down
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Distribution of Products based on sales person and quantity assigned
    By simsidhu8712 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-09-2017, 03:42 PM
  2. Financial Formulas - Payment Allocation to Many Accounts
    By A_Reed in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-22-2017, 11:05 PM
  3. Fill down principal payment & interest payment formulas in Excel
    By Silverthunder in forum Excel General
    Replies: 1
    Last Post: 02-04-2016, 01:03 PM
  4. [SOLVED] Frequency Distribution Formulas
    By zanshin777 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 12-14-2015, 03:12 PM
  5. Excel Macro to determine Sales distribution
    By Aoleone# in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-18-2015, 07:34 AM
  6. Formulas for Batch Distribution
    By bstoudt01 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-05-2014, 07:20 PM
  7. Distribution from lowest stock to highest sales
    By zeez36 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-01-2013, 04:54 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1