Forum Discussion

MMarOO's avatar
MMarOO
Copper Contributor
Feb 25, 2022

Calculating Profit Splits with Additional Rules

I'm trying to calculate the profit split on a job.  The agreement between partners is a 60% profit share for Partner A and 40% profit share for partner B.  However, there is a an additional layer to ...
excel
Formulas and Functions
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Feb 25, 2022

MMarOO As a variant, to the formulae in JU51M3 's schedule you could use:

=MIN(E3,MAX(D3*10%,E3*60%))

for the A share, and

=E3-F3

 for the B share.

  • JU51M3's avatar
    JU51M3
    Copper Contributor
    Feb 26, 2022

    Hai Riny_van_Eekelen ,

     

    Thanks for the improvement ,the formulae you mentioned is easily understandable and also short too👍👍.

     

     

     

  • MMarOO's avatar
    MMarOO
    Copper Contributor
    Feb 25, 2022
    Riny_van_Eekelen thanks for your response. The solution you provided works just as well!

Resources