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.

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