Excel formula help

[redclay01]

Hi all, new to the board. Looking for help with the below formula.

Need formula for rows 12 and 13 where it pulls down from the deal level cash flow but not to a max sum of defined numbers in C2 and C3 respectively. Let me know if this makes sense. Thanks in advance!

 

[Eric W]

Welcome to the MrExcel forum!

How about:

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1
2		LESS SELLER PREF EQUITY	$ 5,000,000.00
3		LESS ROLLED EQUITY	$ 10,558,750.00
4
5
6
7			TOTAL	3/31/2025	4/30/2025	5/31/2025	6/30/2025	7/31/2025	8/31/2025	9/30/2025	10/31/2025	11/30/2025	12/31/2025	1/31/2026	2/28/2026	3/31/2026	4/30/2026	5/31/2026	6/30/2026
8				0	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15
9
10		Deal Level Cash Flow		$(8,030,000.00)	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ 2,431,596.00	$ 6,305,357.00	$ 7,975,250.00	$ 7,975,250.00	$ 7,975,250.00	$ -	$ -
11
12		Less Seller Pref Equity	$ 5,000,000.00	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ 2,431,596.00	$ 2,568,404.00	$ -	$ -	$ -	$ -	$ -
13		Less Rolled Equity to Future Phases	$ 10,558,750.00	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ -	$ 3,736,953.00	$ 6,821,797.00	$ -	$ -	$ -	$ -
Sheet3

Cell Formulas
Range	Formula
E12:S12	E12	=MEDIAN(E10,$C$2-SUM($D12:D12),0)
E13:S13	E13	=IF(SUM($E12:E12)<$C$2,0,MEDIAN(E10-E12,$C$3-SUM($D13:D13),0))
C12:C13	C12	=C2

 

[redclay01]

Man you're a lifesaver. This worked perfectly! Thank you again.

 

[Fluff]

Welcome to the MrExcel Message Board!

For future reference.

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Sum of numbers from a table
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[redclay01]

Welcome to the MrExcel Message Board!

For future reference.

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Sum of numbers from a table
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Thank you for sending. Will review the rules you linked.