+ Reply to Thread
Results 1 to 2 of 2

Need help splitting up amount of my paycheck with my partner

  1. #1
    Registered User
    Join Date
    10-27-2014
    Location
    Illinois
    MS-Off Ver
    2010
    Posts
    13

    Need help splitting up amount of my paycheck with my partner

    Me and Troy are co-owning a small time business.
    Im trying to keep it simple by only keeping us 2 involved, if i can figure out this formula, i should be able to handle the rest by myself

    I get my paycheck once a week.
    Me and Troy are Splitting it, except I am taking 10% of his paycheck and adding it to mine
    this formula so far is easy and simple for me, but this next part is what throws me off.

    We get paid by the days we work in the week. so if i was to work 5 days and he was to work 4, of course we would have to take that into consideration. I have attached a simple excel file that i made real quick, it will kind of show you in more detail.

    typically on a calculator i would take the paycheck amount and divide by the total number of days and multiply it what each person worked,.. and then I also need to take 10% of his check. can someone help me figure this out?
    every time i attempt it, it creates a loop
    In the file attached it has the correct answers for each of us, just no formulas getting me there.
    someone please help
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    08-25-2015
    Location
    Near Pittsburgh, PA
    MS-Off Ver
    Excel 2013
    Posts
    152

    Re: Need help splitting up amount of my paycheck with my partner

    Here you go!
    Pay formula.xlsx

+ 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. PayCheck Spreadsheet
    By fwu713 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-03-2014, 10:21 AM
  2. [SOLVED] get the partner name from range of Partner name and rank to desired range formula
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-19-2014, 11:46 AM
  3. Splitting sales in the least amount of deliveries!
    By kasperblue in forum Excel General
    Replies: 2
    Last Post: 12-17-2012, 12:20 PM
  4. Macro for creating new workbook based on Partner Name
    By sunilwadhwa in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-07-2012, 05:55 PM
  5. Replies: 7
    Last Post: 02-11-2012, 10:11 AM
  6. Different partner each week.
    By SteelySteve in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-03-2008, 07:41 PM
  7. Figuring Out My Paycheck
    By messengerofbob in forum Excel General
    Replies: 1
    Last Post: 11-15-2006, 02:10 PM

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