For loop in excel

[Brix23]

Dear all,

I am having issues creating an equation. I would need to perform an iteration of an equation, namely, everything stays fixed except for one variable which changes in descending order. The output of this calculation is saved the equation is run one more time and the result is again saved. After x amount of times, the results from each equation will be summed together.

So for instance:

((1+r)^n *(1+h)^n) where n changes from i = 6 to i =1. For every run the result is saved and then at the end summed up sum((((1+r)^n *(1+h)^n),(1+r)^n-1 *(1+h)^n-1),....)

I would want to avoid VBA and do it in an equation does anyone know how this could be done?

Best,
Tilen

 

[Fluff]

Hi & welcome to MrExcel.
How about

Fluff.xlsm
	A	B	C
1
2	i	6	55986
3	r	1
4	n	2
Data

Cell Formulas
Range	Formula
C2	C2	=REDUCE(0,SEQUENCE(B2,,B2,-1),LAMBDA(a,b,a+(1+B3)^b*(1+B4)^b))

 

[Brix23]

I was not expecting such a fast answer. Thank you so much.

 

[Fluff]

You're welcome & thanks for the feedback.