+ Reply to Thread
Results 1 to 8 of 8

How to contribute amount from group of people

  1. 03-13-2024, 06:18 AM #1
    asinji
    asinji is offline
    Registered User
    Join Date
    03-07-2015
    Location
    india
    MS-Off Ver
    2010
    Posts
    10

    How to contribute amount from group of people

    Hello Guru’s,
    Please someone help for this?
    I want total amount to divid from 4 person’s like divided by 4 (amount 4.20) but it’s should by minus from whoever paid by.
    For example:
    4.2 / 4 = 1.05
    But amount paid by Mazahir so other 3 persons need to paid 3.15 to Mazahir.
    Please help me with this calculation.
    Thank you and hope someone understand
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-13-2024, 06:37 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,869

    Re: How to contribute amount from group of people

    Are you still using Excel 2010?
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 03-13-2024, 07:06 AM #3
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,869

    Re: How to contribute amount from group of people

    In G2 copied down:

    =IF(TRIM(F2)=D2,E2,E2/(LEN(F2)-LEN(SUBSTITUTE(F2,",",""))+2))

    AliGW on MS365 Beta Channel (Windows 11) 64 bit

    A
    B
    C
    D
    E
    F
    G
    1
    Date
    Amount
    Menu
    Paid By
    Total Amount
    		 Contribute Amount
    2
    11/03/2024
    2.00 ?.?.
    Samosa
    Mazahir
    2.00 ?.?.
    		 Mazahir
    2
    3
    12/03/2024
    2.20 ?.?.
    Pattic
    Mazahir
    4.20 ?.?.
    		 Ali A, Hasan, Ali S
    1.05
    Sheet: Sheet1
    Reply With QuoteRegister To Reply
  4. 03-13-2024, 09:00 AM #4
    asinji
    asinji is offline
    Registered User
    Join Date
    03-07-2015
    Location
    india
    MS-Off Ver
    2010
    Posts
    10
    Quote Originally Posted by AliGW View Post
    In G2 copied down:

    =IF(TRIM(F2)=D2,E2,E2/(LEN(F2)-LEN(SUBSTITUTE(F2,",",""))+2))

    AliGW on MS365 Beta Channel (Windows 11) 64 bit

    A
    B
    C
    D
    E
    F
    G
    1
    Date
    Amount
    Menu
    Paid By
    Total Amount
    		 Contribute Amount
    2
    11/03/2024
    2.00 ?.?.
    Samosa
    Mazahir
    2.00 ?.?.
    		 Mazahir
    2
    3
    12/03/2024
    2.20 ?.?.
    Pattic
    Mazahir
    4.20 ?.?.
    		 Ali A, Hasan, Ali S
    1.05
    Sheet: Sheet1
    Please find the attached updated list for better explanation

    Thank you
    Reply With QuoteRegister To Reply
  5. 03-17-2024, 12:33 PM #5
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,567

    Re: How to contribute amount from group of people

    It may help us understand what you want if you could tell us the expected amounts for cells G2:G5.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
    Reply With QuoteRegister To Reply
  6. 03-17-2024, 10:49 PM #6
    bebo021999
    bebo021999 is offline
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,466

    Re: How to contribute amount from group of people

    Who with amount=0 will take all amount from others
    In G2:
    Please Login or Register  to view this content.
    drag down
    Quang PT
    Reply With QuoteRegister To Reply
  7. 03-18-2024, 03:27 AM #7
    shukla.ankur281190
    shukla.ankur281190 is offline
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,937

    Re: How to contribute amount from group of people

    I think you are dividing the total spend equally among people, but it should be divided based on who paid.


    With a helper column

    H2
    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    G2
    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    Check the attached file.
    Attached Files Attached Files
    Last edited by shukla.ankur281190; 03-18-2024 at 03:35 AM.
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Reply With QuoteRegister To Reply
  8. 03-18-2024, 03:31 AM #8
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,869

    Re: How to contribute amount from group of people

    Quote Originally Posted by asinji View Post
    Please find the attached updated list for better explanation
    How does my solution NOT fit your requirements? This was created using the attachment you provided! I merely simplified the layout to facilitate a formula.
    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. Individual ROI Between a Group of People
    By calliebrin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-09-2023, 03:37 AM
  2. [SOLVED] Formula to count finish times x amount of people
    By MR_STOPA in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-01-2021, 09:02 AM
  3. Sorting from a group of people a selection of 6 up to a given value
    By oggycompton in forum Excel General
    Replies: 0
    Last Post: 05-25-2016, 07:01 AM
  4. Hello to a very exciting group of people
    By neetal in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 06-30-2014, 07:27 PM
  5. HELP!! How can a forumla work out the amount of people at any time?
    By dhaslett in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-17-2013, 04:26 PM
  6. [SOLVED] Sort 6 people into a group of 4 for 20 meetings
    By rookie55 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-14-2013, 11:37 AM
  7. Percentage of people in an age group?
    By ianonline in forum Excel General
    Replies: 17
    Last Post: 03-21-2007, 07:58 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