Scheduling formula with Min/Max limits

[blakhalo]

I need to create a formula that sums a total in column U and Column Q based on the first starting value in column U but limits the total when it reaches the min/max limits in column S and T. Column V is the expected outcome but can't seem to get a formula to keep it within the limits.

 

[maabadi]

Welcome to MrExcel Message board.
If your first cell at V column is V3 and others ay U2 & Q2, Input this at V3 and drag it down.
You can change 12 & 34 to you Min & Max cell address.

=IF(V2="",$U$2+Q2,IF(V2+Q2>34,34,IF(V2+Q2<12,12,V2+Q2)))

 

[Fluff]

Hi & welcome to MrExcel.
Another option

+Fluff v2.xlsm
	Q	R	S	T	U	V
1
2	3	UP	12	34	12
3	3	UP	12	34		15
4	3	UP	12	34		18
5	3	UP	12	34		21
6	3	UP	12	34		24
7	3	UP	12	34		27
8	3	UP	12	34		30
9	3	UP	12	34		33
10	3	UP	12	34		34
11	3	UP	12	34		34
12	3	UP	12	34		34
13	3	UP	12	34		34
14	3	UP	12	34		34
15	3	Up	12	34		34
16	-3	Down	12	34		31
17	-3	Down	12	34		28
18	-3	Down	12	34		25
19	-3	Down	12	34		22
20	-3	Down	12	34		19
21	-3	Down	12	34		16
22	-3	Down	12	34		13
23	-3	Down	12	34		12
24	-3	Down	12	34		12
25	3	up	12	34		15
Main

Cell Formulas
Range	Formula
V3:V25	V3	=IF(R3="up",MIN(SUM(Q3,IF(V2="",U$2,V2)),T2),MAX(SUM(Q3,IF(V2="",U$2,V2)),S2))

 

[Fluff]

If col U will always be blank apart from the 1st row, a simpler formula would be

=IF(R3="up",MIN(SUM(Q3,U2,V2),T2),MAX(SUM(Q3,U2,V2),S2))

 

[Eric W]

How about:

Book1
	Q	R	S	T	U	V
1	UP/DOWN		MIN	MAX	ACTUAL
2	3	UP	12	34	12
3	3	UP	12	34		15
4	3	UP	12	34		18
5	3	UP	12	34		21
6	3	UP	12	34		24
7	3	UP	12	34		27
8	3	UP	12	34		30
9	3	UP	12	34		33
10	3	UP	12	34		34
11	3	UP	12	34		34
12	3	UP	12	34		34
13	3	UP	12	34		34
14	3	UP	12	34		34
15	3	UP	12	34		34
16	-3	DOWN	12	34		31
17	-3	DOWN	12	34		28
18	-3	DOWN	12	34		25
19	-3	DOWN	12	34		22
20	-3	DOWN	12	34		19
21	-3	DOWN	12	34		16
22	-3	DOWN	12	34		13
23	-3	DOWN	12	34		12
24	-3	DOWN	12	34		12
25	3	UP	12	34		15
26	3	UP	12	34		18
27	3	UP	12	34		21
28	3	UP	12	34		24
29	3	UP	12	34		27
30	3	UP	12	34		30
31	3	UP	12	34		33
32	3	UP	12	34		34
33	3	UP	12	34		34
34	3	UP	12	34		34
Sheet9

Cell Formulas
Range	Formula
V3:V34	V3	=MEDIAN(S3,T3,U2+V2+Q3)

 

[blakhalo]

Thanks! Works great!

 

[Eric W]

Glad we could help! Thanks for the feedback.