Hi, is there a way to use CL to create a calculated column in a table? I want students to calculate and enter probabilities in one column and have the table automatically multiply those probabilities by 50 and show the result in the next column. Many thanks!

This should do the trick, assuming your probabilities are in column 1 and the product should be in column 2. If you need another row, just duplicate the code and change the (1,1) and (1,2) to (2,1) and (2,2), respectively. cellContent(1,2): when isDefined(this.cellNumericValue(1,1)) "${numericValue…

[image] cwinske: cellContent(1,2): when isDefined(this.cellNumericValue(1,1)) "${numericValue("${this.cellNumericValue(1,1)}*50")}" otherwise "" Thank you that is brilliant!

I wanted to do something similar but instead take the square root of the number in cell(1,1). I used the same code but wanted instead of multiplying by 50 I tried ^0.5. I get an error when raising the number to 1/2 (0.5) but it works when square the number (ie ^2). I also tried ^(0.5) and it also…

Change the code to the last cell to [Screen Shot 2021-09-20 at 8.57.55 PM]

Thank you StoyanNYC. I was forgetting the \ when I tried sqrt before… However this formula is only working for 1 digit numbers? I did a test on input of 9 and output is 3, but a test of input 25 gets me output of 7.07. What am I missing? P.S. I reformatted the table to only do square root …

I edited the script above and now it should work… you need {0.5}, not (0.5)

Ahhh. Gotcha. Yes that solved it. Thanks. Weird how the other script with \sprt didn’t always work, but nice that ^{0.5} did. Thanks!

Yes… I’d like to figure out why the \sqrt works for x<10 but not after…

Great minds think alike! I created a table just like you just posted in the new post. Thanks for doing that! [image] Why different result for table calculation? Questions This is courtesy of @chrisleechss . Both columns of the table below are supposed to calculate the squ…

No problem… I’m really curious. Let’s see if someone has an answer.

Performing calculations within a table

Questions

chrisleechss (Chris Lee) September 21, 2021, 1:29am 10

Great minds think alike! I created a table just like you just posted in the new post. Thanks for doing that!

Topic		Replies	Views
Why different result for table calculation? Questions	2	446	September 21, 2021
Check a table value with a sqrt Questions	2	531	May 6, 2021
Perform calculations with numbers in a table Questions	12	12557	April 7, 2021
Multiplying table cell values Questions	2	887	May 2, 2022
Giving student feedback based on multiple cells Questions	6	609	January 20, 2022

Performing calculations within a table

Related topics