Changing a formula location based on an integer in a cell

[mike2022]

Hello! I am trying to move a SEQUENCE formula to the right X number of rows. Using the attached picture as an example:

• Currently I have a sequence evenly dividing my notional over the number of years (5) stated in B4
• I would like to dynamically push that sequence 'X' cells to the right based on B5 (i.e. in this case push forward 3 years so the sequence begins the 5y payback in 2024)

Thank you for checking!

 

[jasonb75]

Is this what you're trying to do?

Book1
	B	C	D	E	F	G	H	I	J	K	L	M	N
2			2021	2022	2023	2024	2025	2026	2027	2028	2029	2030	2031
3	100					20	20	20	20	20
4	5
5	3
Sheet1

Cell Formulas
Range	Formula
D3:K3	D3	=IF(SEQUENCE(,B4+B5)>B5,B3/B4,"")
Dynamic array formulas.

 

[mike2022]

Thanks very much jasonb75! This does the trick, much appreciated.