# [LON-CAPA-users] (no subject)

Gerd Kortemeyer kortemey at msu.edu
Mon Nov 2 17:29:47 EST 2015

```Hi,

Maybe try the builtin function int:

int(0.5+1000.*\$z)/1000.

- Gerd.

> On Nov 2, 2015, at 5:13 PM, Rex Abert <ABERTR at 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-bounces at mail.lon-capa.org [lon-capa-users-bounces at mail.lon-capa.org] on behalf of Lucas, Mark [lucasm at 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 <ABERTR at 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 at mail.lon-capa.org
>> http://mail.lon-capa.org/mailman/listinfo/lon-capa-users
>
> --
> Mark Lucas                                                              email: lucasm at 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 at mail.lon-capa.org
> http://mail.lon-capa.org/mailman/listinfo/lon-capa-users
> _______________________________________________
> LON-CAPA-users mailing list
> LON-CAPA-users at 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/

```