Help with spreadsheet formula

04302023, 06:30 AM
Post: #1




Help with spreadsheet formula
Hello, I'm trying to define a formula for the spreadsheet app using this function
Code: EXPORT cdf_bin_table(n) However would like 'n' to be replaced with the input value. Can I please get a suggestion on how to do this? I've been trying some different combinations of quote, eval, expr, but with what I've tried so far I still have to replace n manually, or every cell is defined as a string. For reference I'm just recreating a table of values for the binomial cdf, and I've set column A to be Row2, and put some different probabilities in row 1.  neek 

04302023, 09:58 AM
Post: #2




RE: Help with spreadsheet formula
Did you try this:
EXPORT cdf_bin_table(n) BEGIN STARTAPP("Spreadsheet"); LOCAL s; s:="QUOTE(BINOMIAL_CDF(" + n + ",Cell(1,Col),Cell(Row,1)))"; Cell(0,0):=EXPR(s); END; road 

« Next Oldest  Next Newest »

User(s) browsing this thread: 1 Guest(s)