# calc - CALCulate mathematical formulae [closed]

Say I have three parameters:

m (in cell B2)
lambda (in cell B7)
mu (in cell B8)


where I can easily calculate

rho = lambda/(m*mu)  (in cell B10)


I now want to calculate

p0 = 1/(1 + (m * rho)^m/(m!*(1-rho)) + sum[n=1 to m-1]( (m*rho)^n / n!) )

How do I enter the sum?

(1/(1+(B2 * (B7/(B2*B8)))^B2/(FACT(B2) * (1-(B7/(B2*B8)))) + ???))

note: I'm generating these formulae in bash so I don't need to use named cells and can re-use the generated formulae by copying the column and changing the parameters for your convenience:

lambda="B7"
mu="B8"
m="B2"

rho="($lambda/($m*$mu))" echo -e "rho =\n\t$rho"

p0="(1/(1+($m *$rho)^$m/(FACT($m) * (1-$rho)) + ???))" echo -e "p0 =\n\t$p0"

edit retag reopen merge delete