[LON-CAPA-users] (no subject)
ABERTR at tcc.fl.edu
Mon Nov 2 16:40:07 EST 2015
I have a question about rounding values to, say, 3 or 4 digits in the spreadsheet. I've come up with the following hack that does the job, but i was wondering if there was a more elegant (built-in?) way to do it.
$x = &SUMSEQ("T","regexp:Homework")/&SUMSEQ("S","regexp:Homework")*100;
$x *= 1000;
$x = int($x);
$x /= 1000;
In the above code, columns S and T contain points available and points earned, depending on whether the due date has passed or not.
Associate Professor of Mathematics
Tallahassee Community College
More information about the LON-CAPA-users