Wai,
If you want 3, 3.1, 3.4, 3.5. 3.6, 3.9 et al to round up to 4 use:
#ceiling(3.4)# 3.4 being any number
If you want 3, 3.1, 3.4, 3.5. 3.6, 3.9 et al to round down to 3 use:
#fix(3.4)# 3.4 being any number
Hope That Helps
Rick
----- Original Message -----
From: "Mark Ireland" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 25, 2000 6:25 PM
Subject: Re: Round down numbers
>
> Its quick and dirty but . . .
> minus one from the number first
>
> leave a long explanation in the comments for the poor guy who has to read
> that bit of code one day :)
>
>
> At 11:23 AM 26/07/00 +1000, you wrote:
> >
> >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
> >
>
> --------------------------------------------------------------------------
----
> 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.
__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com
------------------------------------------------------------------------------
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.
