Results 1 to 10 of 10

Split an amount based on shares and number of people

Threaded View

  1. #1
    Registered User
    Join Date
    04-02-2024
    Location
    Ireland
    MS-Off Ver
    Office 365
    Posts
    6

    Post Split an amount based on shares and number of people

    Hi,

    Attached file got two sheets. one with amount and second with the amount split based on shares.

    If you enter a figure in the shares column, it is then split into that many rows but I want this amount shown per person on the next row only and same with 50% share. so the split value shown on e12 for 100% share and f12 for 50% share.

    Could someone please assist with this formula?

    Thanks & regards,
    JTom2024
    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. Allocate a total to 10 people based on shares
    By jtom2024 in forum Excel General
    Replies: 6
    Last Post: 04-22-2024, 11:17 AM
  2. [SOLVED] Split Amount According to Voucher Number
    By HaroonSid in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-10-2023, 09:13 AM
  3. Total Split Amount Based on Split Group
    By BillySpivy in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-14-2021, 05:50 AM
  4. Split Amount Based on condition for specific cell value.
    By Abdur_rahman in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-16-2020, 05:47 AM
  5. Split Amount Based on condition
    By Abdur_rahman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-19-2020, 02:00 AM
  6. Replies: 1
    Last Post: 02-13-2019, 05:09 AM
  7. Replies: 1
    Last Post: 02-25-2015, 10:48 AM

Tags for this Thread

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