Need help in a sequencing formula, cant figure how to extend to additional values.

[born2dive00]

Ok so I have NO idea how to do this, in di sheet under J3:J6 I have these formulas

=$H4^2 / ($H4^2+F$4*$H4+$F$4*$F$5)
=$F$4*$H4 / ($H4^2+$F$4*$H4+$F$4*$F$5)
=$F$4*$F$5 / ($H4^2+$F$4*$H4+$F$4*$F$5)

These calculate the 2 values in C4, C5

Now when I need to calculate 3 values C4:C6 as in the Tri sheet under J3:J7 the formula becomes

=$H4^3 / ($H4^3+($F$4*$H4^2)+($F$4*$F$5*$H4)+($F$4*$F$5*$F$6))
=$F$4*$H4^2 / ($H4^3+($F$4*$H4^2)+($F$4*$F$5*$H4)+($F$4*$F$5*$F$6))
=$F$4*$F$5*$H4 / ($H4^3+($F$4*$H4^2)+($F$4*$F$5*$H4)+($F$4*$F$5*$F$6))
=$F$4*$F$5*$F$6 / ($H4^3+($F$4*$H4^2)+($F$4*$F$5*$H4)+($F$4*$F$5*$F$6))

What I dont know is how to make the required formulas to calculate
4 values C4:C7 in the Quad sheet
5 values C4:C8 in the Penta sheet
6 values c4:c9 in the Hexa sheet

Can some one help me out extending the formula to calculate the 6 values in the Hexa sheet please.

I see a slight pattern, however i can not figure out how it extends.

Please help
Brad

[mehmetcik]

Hi

I do not have the time at the moment.

However I think that you need to use the Product and Indirect functions on your TRI Sheet to simplify your formulae.

You will then be able to expand on them without issue.

Formula for F1 =MATCH(9^99,F:F)

Formula for J4 =$F$4*$H4^2 / ($H4^3+($F$4*$H4^2)+PRODUCT($H4,F4:F5)+PRODUCT(INDIRECT("$F$4:$F$" &$F$1)))
Formula for J5 =$F$4*$H4^2 / ($H4^3+($F$4*$H4^2)+PRODUCT($H4,F4:F5)+PRODUCT(INDIRECT("$F$4:$F$" &$F$1)))
Formula for J6 =$F$4*$F$5*$H4 / ($H4^3+($F$4*$H4^2)+PRODUCT($H4,F4:F5)+PRODUCT(INDIRECT("$F$4:$F$" &$F$1)))
Formula for J7 =$F$4*$F$5*$F$6 / ($H4^3+($F$4*$H4^2)+PRODUCT($H4,F4:F5)+PRODUCT(INDIRECT("$F$4:$F$" &$F$1)))