RE: [sqr-users] rounding to thousand

[kevin.reschenberg@sparkpath.com]

let #Result = floor((#Number + 500) / 1000) * 1000
 
Kevin Reschenberg
SparkPath Technologies, Inc.

sparkpath.com | sqr-info.com


> -------- Original Message --------
> Subject: [sqr-users] rounding to thousand
> From: "radhika reddy" <radhika_05@hotmail.com>
> Date: Tue, January 31, 2006 8:05 am
> To: sqr-users@sqrug.org
> 
> Hi,
> 
>   I have to round a number to thousands like the following:
> 
> Number          Result
> 6590.78         7000.00
> 5343.00         5000.00
> 3000.00         3000.00
> 
> I am not able to achieve this through Round function. Can you tell me is 
> there any function or how to achieve this.
> 
> Thanks,
> Radhika
> 
> _________________________________________________________________
> FREE pop-up blocking with the new MSN Toolbar – get it now! 
> http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/
> 
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users