I want to create a formula with scripted variable Factorials inside a loop.
How can I DIM the variables outside the loop, and DEFINE a function outside the loop that works inside with changing arguments?
67Turq
Last Activity: May 6 '21, 02:58 AM
Joined: Apr 28 '21
Location:
-
defining a function that uses scripted variables
-
Execute a function inside a loop
I'm a beginner, and I'm trying to execute a FACTORIAL calculation inside a For - Next loop.
E=8
Eg.-
For f = 0 to E
Cells (f+1, 1) = Fact(E)/(Fact(f)*Fact(E ))
Next F
How can I define the function for that calculation?
No activity results to display