revenue sharing formula help

[jasonvee]

Hi,

Thank you in advance for helping.
The company has a revenue sharing contract for 10% of the revenue starting when the company reaches $100,000 per month (month 7) in revenue until all $125,000 of the contracted amount of paid off (month 14)

Need a formula in the revenue sharing row to stop going forward until 125,000 total is reached

 

[John Jairo V]

Hi, @jasonvee!

Check this formula in B3 and drag it to the right:
=(B2>100000)*MEDIAN(,B2*$B$6,$B$8-SUM($A3:A3))

Check file. Blessings!

 

[jasonvee]

thank you so much!

 

[jasonvee]

Question -

How would the formula look like if the company has a revenue sharing contract for 10% of the revenue starting when the company reaches $100,000 cumulatively in revenue until all $125,000 of the contracted amount of paid off

 

[John Jairo V]

Hi, again!

I don't understand your new question. Put in your excel your expected results by hand, and share the workbook. Blessings!

 

[jasonvee]

Hi John,

Thank you for helping.

In the original example - the 10% revenue sharing started when monthly revenue (row A)turned 100,000 per month at column I.

The new scenario is -

10% revenue sharing starts when sum of monthly revenue (row A) adds up to 100,000 (column E)

 

[John Jairo V]

Is this what you want?

[B3] : =(SUM($B2:B2)>100000)*MEDIAN(,B2*$B$5,$B$7-SUM($A3:A3))

If not, Put in your excel your expected results by hand. Blessings!