> I have been using the round() function. It rounds up or down to
> the nearest
> whole number only. Am I wrong on this? how can I round up decimal
> numbers. I
> need to round a number like 1.41 to 1.50. I'm doing a timecard application
> and I need to round to quarters .25 .50 .75 1.0 What would be a
> good way to
> do this with CF or what functions can help me with this problem.

Here's an interesting solution, but maybe not the best...

If you only want to round to the nearest half - double the number, Round()
it, then halve it

If you want to round to the quarter - quadrouple the number, Round() it,
then quarter it

This _should_ give you want you want...

HTH

Philip Arnold
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************


------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
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.

Reply via email to