Duplicate value amongst multiple rows determined on value of cell

[Blake0920]

Hi there,

I am trying to replicate a value into multiple rows based on the value of a cell.

I need to replicate U5 eight(8) times beginning in P12:P18.

Essentially I have a payment plan and some customers have stopped paying. I need to project how much less that will be each month based on how many months they have remaining.

In other words is there a way I can have $107.92 appear in the range of cells without have to input in manually?

Sales Orders 2022-2.1 - Blake.xlsm
	M	N	O	P	Q	R	S	T	U	V
4	mo payment			Name	Cancel Date	OG Mo PP	Owing	Duration	Mo.	Total
5					02-15-2022	12	$863.33	8	$107.92	1
6	3				02-16-2022	6	573.21	3	$191.07	1
7	6
8	9
9	12
10
11		Current		Owing		Reduced
12	feb	$31,492.43	mar	$107.92		$31,384.52
13	mar	$27,025.93	apr			$27,025.93
14	apr	$24,164.54	may			$24,164.54
15	may	$23,292.13	jun			$23,292.13
16	jun	$20,192.76	jul			$20,192.76
17	jul	$17,857.81	aug			$17,857.81
18	aug	$15,584.18	sep			$15,584.18
19	sep	$13,762.83	oct			$13,762.83
20	oct	$11,715.20	nov			$11,715.20
21	nov	$9,562.18	dec			$9,562.18
22	dec	$5,771.53	jan			$5,771.53
23	jan	$1,095.00	feb			$1,095.00
24	feb		mar
PP Mo

Cell Formulas
Range	Formula
U5:U6	U5	=S5/T5
P12	P12	=SUM((Q5>="02-01-2022")*(Q5<="02-31-2022")*U5)
N12	N12	=(D5/J5)/M9*(J5)+(D8/J8)/M9*(J8)+(D11/J11)/M9*(J11)+(D14/J14)/M9*(J14)+(D17/J17)/M9*(J17)+(D20/J20)/M9*(J20)+(D23/J23)/M9*(J23)+(D26/J26)/M9*(J26)+(D29/J29)/M9*(J29)+(D32/J32)/M9*(J32)+(D35/J35)/M9*(J35)+(D38/J38)/M9*(J38)
N13	N13	=(D38/M9)+(D35/12)+(D23/12)+(D26/12)+(D29/12)+(D32/12)+(D8/12)+(D11/12)+(D14/12)+(D17/12)+(D20/12)
N14	N14	=(D38/M9)+(D35/12)+(D23/12)+(D26/12)+(D29/12)+(D32/12)+(D11/12)+(D14/12)+(D17/12)+(D20/12)
N15	N15	=(D38/M9)+(D35/12)+(D23/12)+(D26/12)+(D29/12)+(D32/12)+(D14/12)+(D17/12)+(D20/12)
N16	N16	=(D38/M9)+(D35/12)+(D23/12)+(D26/12)+(D29/12)+(D32/12)+(D17/12)+(D20/12)
N17	N17	=(D38/M9)+(D35/12)+(D23/12)+(D26/12)+(D29/12)+(D32/12)+(D20/12)
N18	N18	=(D38/M9)+(D35/12)+(D23/12)+(D26/12)+(D29/12)+(D32/12)
N19	N19	=(D38/M9)+(D35/12)+(D26/12)+(D29/12)+(D32/12)
N20	N20	=(D38/M9)+(D35/12)+(D29/12)+(D32/12)
N21	N21	=(D38/M9)+(D35/12)+(D32/12)
N22	N22	=(D38/M9)+(D35/12)
N23	N23	=(D38/M9)
N24	N24	=(D41/M9)
R12:R23	R12	=N12-P12
R24	R24	=N24+P24

 

[Fluff]

Duplicate to: Subtract value over multiple cells

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.