+ Reply to Thread
Results 1 to 5 of 5

ISO Dynamic Profit Sharing Formula

  1. #1
    Registered User
    Join Date
    01-12-2016
    Location
    Houston, TX
    MS-Off Ver
    Office 2013
    Posts
    3

    ISO Dynamic Profit Sharing Formula

    I am trying to create a profit sharing compensation model (see attached).

    Each employee's percentage of the profits is based on three categories with a 0-1 scale. If everyone is a 1, it's easy.

    My question: If someone gets less than a 1 in a category, thus lowering their portion of the profits, how do I add the difference to the others?

    I was thinking there might be something with MAX or MIN, but I couldn't figure it out.

    Thanks for the help!
    Attached Files Attached Files

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: ISO Dynamic Profit Sharing Formula

    =$c$4*sumproduct($c$6:$c$8*c13:c15/$g$13:$g$15)
    Attached Files Attached Files

  3. #3
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,616

    Re: ISO Dynamic Profit Sharing Formula

    Try O13 and copy down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    then adjusted formula in C17 and copied to next employees is:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    so instead of dividing always by no of employees (C10) we divide by the sum of factors in each row.
    Attached Files Attached Files
    Best Regards,

    Kaper

  4. #4
    Registered User
    Join Date
    01-12-2016
    Location
    Houston, TX
    MS-Off Ver
    Office 2013
    Posts
    3

    Re: ISO Dynamic Profit Sharing Formula

    Perfect! Thanks, Tim!

  5. #5
    Registered User
    Join Date
    01-12-2016
    Location
    Houston, TX
    MS-Off Ver
    Office 2013
    Posts
    3

    Re: ISO Dynamic Profit Sharing Formula

    Thanks, Kaper!

+ 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. Profit Formula ?
    By craigbai in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 06-01-2014, 05:07 PM
  2. Replies: 1
    Last Post: 02-24-2014, 01:46 PM
  3. Replies: 0
    Last Post: 01-21-2014, 12:04 PM
  4. How we unprotect Sharing Password if Vba Project is unviewable ........ Creak Sharing Pas
    By shahidanwar0 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-20-2013, 01:10 PM
  5. 1. consecutive days of profit and of losses 2. biggest profit loss since date
    By xbohemianx in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-14-2013, 12:57 PM
  6. [SOLVED] Formula (profit sharing) help needed
    By invgrp in forum Excel General
    Replies: 4
    Last Post: 07-27-2012, 02:23 PM
  7. Profit formula
    By cas91 in forum Excel General
    Replies: 4
    Last Post: 01-04-2010, 08:51 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