Well are you talking about rounding or dropping the decimal places.
For example Fix(number) will remove the decimal places, however if you
wanted .80 to round up you will need to get the numbers from the decimal
place and do the maths yourself.
-----Original Message-----
From: wai-leng [mailto:[EMAIL PROTECTED]]
Sent: 26 July 2000 11:23
To: cftalk
Subject: Round down numbers
This is a multi-part message in MIME format.
------=_NextPart_000_0624_01BFF6F3.E534ECC0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi all,
I am using Round () to round numbers but I would like it to round down =
ie 469.50 should be evaluated as 469 instead of 470.
Any suggestions please
Thanks in advance
wai leng
------=_NextPart_000_0624_01BFF6F3.E534ECC0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2614.3500" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi all,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>I am using Round () to round numbers =
but I would=20
like it to round down ie 469.50 should be evaluated as 469 instead of=20
470.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Any suggestions please</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks in advance</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>wai leng</FONT></DIV></BODY></HTML>
------=_NextPart_000_0624_01BFF6F3.E534ECC0--
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.