Hello,

I find myself in a need of a macro or a formula that would solve the following.

In G1 I've got a number or iterations, which is going to change, depending on other conditions.
In H1 I've got a constant- but it will also change depending on other conditions which is not ipmortant at the moment. Though it has to be stored in this cell, but for the following columns both can be considered constant numbers.
In column "I" I need to perform a subtraction of:
for i=1 to G1 do
I(i)-H1

Similarly in column 'J'
for i=1 to G1 do
D(i)*(1-0,1)^F(i)

Could someby be so kind and post either a formula or a macro that would do the above? I'm fairly new to excel and don't know vba script yet.