Rounding in QUIZ
Dennis Hassell
dennis@dhassell.com
Mon, 4 Aug 2003 13:24:50 -0400
This is a multi-part message in MIME format.
------=_NextPart_000_003C_01C35A8B.C8DCE6A0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
There are 3 options:
CEILING(NUMBER) for the next more positive integer (works on negative
#'s, too)
FLOOR(NUMBER) for the next less positive integer.
FLOOR and CEILING were designed mostly for whole dollar calculations.
ROUND(NUMBER,PRECISION,OPTION)
Where NUMBER is the number to be rounded, PRECISION is the #
of decimal places, e.g. 1 is tenths (111.1) and -1 is tens (110),
and OPTION is one of NEAR (default), UP, DOWN, and ZERO.
CEILING(X) is the same as ROUND(X,0,ZERO), FLOOR(X) is the same as
ROUND(X,0,DOWN)
In your case, for 1.111115 to round to 1.111120 . and 1.111114 to round
to 1.111110 . , use ROUND(X,5,NEAR), or ROUND(X,5).
Dennis Hassell
Dennis Hassell and Associates
(941) 746-4919
(941) 224-3981 - cell
-----Original Message-----
From: powerh-l-admin@cube.swau.edu [mailto:powerh-l-admin@cube.swau.edu]
On Behalf Of Robert Mills
Sent: Monday, August 04, 2003 11:43 AM
To: PowerHouse Mail List (E-mail)
Subject: Rounding in QUIZ
Have just been asked if there is a way to make Quiz 'Round' an item to
the nearest 5 (five).
Any suggestions?
regards,
Robert W.Mills
Systems Development Manager
Windsong Services
(01689) 870622 x3005
------=_NextPart_000_003C_01C35A8B.C8DCE6A0
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<html>
<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 10 (filtered)">
<title>Rounding in QUIZ</title>
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p
{margin-right:0in;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle18
{font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>There are 3 =
options:</span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>CEILING(NUMBER) for the next more =
positive
integer (works on negative #’s, too)</span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>FLOOR(NUMBER) for the next less =
positive
integer.</span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>FLOOR and CEILING were designed =
mostly for
whole dollar calculations.</span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>ROUND(NUMBER,PRECISION,OPTION)</span=
></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'> =
Where
NUMBER is the number to be rounded, PRECISION is the # of decimal =
places, e.g.
1 is tenths (111.1) and -1 is tens (110),</span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'> =
and
OPTION is one of NEAR (default), UP, DOWN, and ZERO.</span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>CEILING(X) is the same as =
ROUND(X,0,ZERO),
FLOOR(X) is the same as ROUND(X,0,DOWN)</span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>In your case, for 1.111115 to round =
to 1.111120
… and 1.111114 to round to 1.111110 … , use =
ROUND(X,5,NEAR),
or ROUND(X,5).</span></font></p>
<div>
<p><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;font-family:
Arial;color:navy'>Dennis Hassell</span></font><font color=3Dnavy><span
style=3D'color:navy'> <br>
</span></font><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial;color:navy'>Dennis Hassell and =
Associates</span></font><font
color=3Dnavy><span style=3D'color:navy'> <br>
</span></font><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial;color:navy'>(941) 746-4919</span></font><font =
color=3Dnavy><span
style=3D'color:navy'> <br>
</span></font><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial;color:navy'>(941) 224-3981 - cell</span></font><font
color=3Dnavy><span style=3D'color:navy'> </span></font></p>
</div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
face=3DTahoma><span
style=3D'font-size:10.0pt;font-family:Tahoma'>-----Original =
Message-----<br>
<b><span style=3D'font-weight:bold'>From:</span></b> =
powerh-l-admin@cube.swau.edu
[mailto:powerh-l-admin@cube.swau.edu] <b><span =
style=3D'font-weight:bold'>On
Behalf Of </span></b>Robert Mills<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> Monday, August 04, =
2003
11:43 AM<br>
<b><span style=3D'font-weight:bold'>To:</span></b> PowerHouse Mail List =
(E-mail)<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> Rounding in =
QUIZ</span></font></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'> </span></font></p>
<p style=3D'margin-left:.5in'><font size=3D2 face=3D"Times New =
Roman"><span
style=3D'font-size:10.0pt'>Have just been asked if there is a way to =
make Quiz
'Round' an item to the nearest 5 (five).</span></font> </p>
<p style=3D'margin-left:.5in'><font size=3D2 face=3D"Times New =
Roman"><span
style=3D'font-size:10.0pt'>Any suggestions?</span></font> </p>
<p style=3D'margin-left:.5in'><font size=3D2 face=3D"Times New =
Roman"><span
style=3D'font-size:10.0pt'>regards,</span></font> </p>
<p style=3D'margin-left:.5in'><font size=3D2 face=3D"Times New =
Roman"><span
style=3D'font-size:10.0pt'>Robert W.Mills</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>Systems Development =
Manager</span></font>
<br>
<font size=3D2><span style=3D'font-size:10.0pt'>Windsong =
Services</span></font> <br>
<font size=3D2><span style=3D'font-size:10.0pt'>(01689) 870622 =
x3005</span></font> </p>
</div>
</body>
</html>
------=_NextPart_000_003C_01C35A8B.C8DCE6A0--