I've been mostly into Python but need to use an existing excel workbook and do some some curve fitting using excel solver
I shall be grateful if some can help me with what these formulae in excel mean
1) =IF(AND(X26="Y",Y26=1), IF(H26/G26>=0, (G26-H26)*(1-H26/G26)^($L$3-1),(G26-H26)*(1-H26/G26)^($L$4-1)), #N/A)
2) =IF(E26=0.127, F26, #N/A)
3) =MAX(1E-50,IF(J11="BROKEN", NORM.DIST(LN(F11), LN(P11), $R$5,FALSE), 1-NORM.DIST(LN(F11), LN(P11), $R$5, TRUE)))
Thanks a lot for the help
Jo
Bookmarks