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
Bookmarks