Hello.
There is the perl builtin 'sprintf ' Does $y = sprintf '%.3f', $z; work? (Could not test it. What is the 'spreadsheet'?) Peter On 11/02/2015 11:13 PM, Rex Abert 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 > -- Dr. Peter Dencker wissenschaftl. Mitarbeiter UNIVERSITÄT ZU LÜBECK INSTITUT FÜR MATHEMATIK Ratzeburger Allee 160 23562 Lübeck Tel +49 451 500 4254 Fax +49 451 500 3373 denc...@math.uni-luebeck.de www.math.uni-luebeck.de _______________________________________________ LON-CAPA-users mailing list LON-CAPA-users@mail.lon-capa.org http://mail.lon-capa.org/mailman/listinfo/lon-capa-users