I've tried turning this one:

=if(B6="";"";combin((D6 (F6 1));(F6 1))*((F6 1)/(D6 (F6 1)))^(F6 1)*(((D6 (F6 1))-(F6 1))/(D6 (F6 1)))^((D6 (F6 1))-(F6 1)))

by doing it like this:

=ARRAYFORMULA(if(B6:B="";"";combin((D6:D (F6:F 1));(F6:F 1))*((F6:F 1)/(D6:D (F6:F 1)))^(F6:F 1)*(((D6:D (F6:F 1))-(F6:F 1))/(D6:D (F6:F 1)))^((D6:D (F6:F 1))-(F6:F 1)))

but it keeps giving me the wrong result. What would be the approach here?

Thank you!

CodePudding user response：

It is because you use open ranges like F6:F. In your calculations you have (F6:F 1). This will keep expanding for ever.

Try closing the ranges using a maximum number which would be your existing rows minus one.
Like if you sheet has 888 rows try the maximum F6:F887