Hi,
Maybe try the builtin function int:
int(0.5+1000.*$z)/1000.
- Gerd.
> On Nov 2, 2015, at 5:13 PM, Rex Abert <abe...@tcc.fl.edu> wrote:
>
> Mark-
>
> I've tried that. The function &roundto($x,$n) works fine in problem scripts,
> but returns "undefined" in the spreadsheet.
>
> Rex Abert
> Associate Professor of Mathematics
> Tallahassee Community College
> ________________________________________
> From: lon-capa-users-boun...@mail.lon-capa.org
> [lon-capa-users-boun...@mail.lon-capa.org] on behalf of Lucas, Mark
> [luc...@ohio.edu]
> Sent: Monday, November 2, 2015 5:01 PM
> To: Discussion list for LON-CAPA users
> Subject: Re: [LON-CAPA-users] (no subject)
>
> Rex,
>
> There is a function: roundto(x,n) available in perl safe space within the
> coding of a
> problem. You might try it to see if it works in the spreadsheet.
>
> $y = &roundto($z,3);
>
> will round z to 3 decimal places.
>
> Later,
> Mark
>
>
> On Nov 2, 2015, at 4:40 PM, Rex Abert <abe...@tcc.fl.edu> wrote:
>
>> 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;
>> $x;
>>
>> In the above code, columns S and T contain points available and points
>> earned, depending on whether the due date has passed or not.
>>
>> Rex Abert
>> Associate Professor of Mathematics
>> Tallahassee Community College
>> _______________________________________________
>> LON-CAPA-users mailing list
>> LON-CAPA-users@mail.lon-capa.org
>> http://mail.lon-capa.org/mailman/listinfo/lon-capa-users
>
> --
> Mark Lucas
> email: luc...@ohiou.edu
> 252D Clippinger Lab phone:
> (740)597-2984
> Department of Physics and Astronomy fax: (740)593-0433
> Ohio University
> Athens, OH 45701
>
> _______________________________________________
> LON-CAPA-users mailing list
> LON-CAPA-users@mail.lon-capa.org
> http://mail.lon-capa.org/mailman/listinfo/lon-capa-users
> _______________________________________________
> LON-CAPA-users mailing list
> LON-CAPA-users@mail.lon-capa.org
> http://mail.lon-capa.org/mailman/listinfo/lon-capa-users
--
Gerd Kortemeyer, Ph.D.
Associate Professor of Physics
Director, LON-CAPA Project
Michigan State University
http://www.msu.edu/user/kortemey/
_______________________________________________
LON-CAPA-users mailing list
LON-CAPA-users@mail.lon-capa.org
http://mail.lon-capa.org/mailman/listinfo/lon-capa-users
