Simple Math function

[Agnes]

my number is 100.1 , Now I only want to get 100 without any round up or
round down function,
Can anyone told me which function can do that ?
Thanks

[Tom Shelton]

On 2004-10-07, Agnes <ag***@dynamict ech.com.hk> wrote:

my number is 100.1 , Now I only want to get 100 without any round up or
round down function,
Can anyone told me which function can do that ?
Thanks

You'll want to look at the Int or the Fix function - depending on how
you want negative number handled. Here are the remarks from the
function reference:

http://msdn.microsoft.com/library/de...l/vafctint.asp
Remarks

Both the Int and Fix functions remove the fractional part of number and
return the resulting integer value.

The difference between Int and Fix functions is that if number is
negative, Int returns the first negative integer less than or equal to
number, whereas Fix returns the first negative integer greater than or
equal to number. For example, Int converts -8.4 to -9, and Fix converts
-8.4 to -8.

Fix(number) is equivalent to Sign(number) * Int(Abs(number) ).

HTH
--
Tom Shelton [MVP]

[Agnes]

Thanks Tom, now, How can I get "1"
Dim decCent As Decimal = 100.3- Int(100.3) , now decCent get 0.29999999999
but not 0.3
Please help
"Tom Shelton" <to*@YOUKNOWTHE DRILLmtogden.co m> ¦b¶l¥ó
news:uh******** ******@TK2MSFTN GP09.phx.gbl ¤¤¼¶¼g...

On 2004-10-07, Agnes <ag***@dynamict ech.com.hk> wrote:

my number is 100.1 , Now I only want to get 100 without any round up or
round down function,
Can anyone told me which function can do that ?
Thanks
You'll want to look at the Int or the Fix function - depending on how
you want negative number handled. Here are the remarks from the
function reference:

http://msdn.microsoft.com/library/de...l/vafctint.asp Remarks

Both the Int and Fix functions remove the fractional part of number and
return the resulting integer value.

The difference between Int and Fix functions is that if number is
negative, Int returns the first negative integer less than or equal to
number, whereas Fix returns the first negative integer greater than or
equal to number. For example, Int converts -8.4 to -9, and Fix converts
-8.4 to -8.

Fix(number) is equivalent to Sign(number) * Int(Abs(number) ).

HTH
--
Tom Shelton [MVP]

[Jay B. Harlow [MVP - Outlook]]

Agnes,
100.3 is not a Decimal number its a double, try:

Dim decCent As Decimal = 100.3D - Int(100.3D) , now decCent get
0.29999999999
The D after 100.3 indicates it is a Decimal literal, not a Double literal.

In addition to Int & Fix that Tom suggested, there are Decimal.Floor,
Decimal.Truncat e, Math.Floor, Math.Ceiling & possible other methods on
either Decimal, Math, Single, Double.

For an explanation of the differences between a Decimal & Double see:

http://www.yoda.arachsys.com/csharp/floatingpoint.html
http://www.yoda.arachsys.com/csharp/decimal.html

Hope this helps
Jay

"Agnes" <ag***@dynamict ech.com.hk> wrote in message
news:O7******** *****@tk2msftng p13.phx.gbl... Thanks Tom, now, How can I get "1"
Dim decCent As Decimal = 100.3- Int(100.3) , now decCent get 0.29999999999
but not 0.3
Please help
"Tom Shelton" <to*@YOUKNOWTHE DRILLmtogden.co m> ¦b¶l¥ó
news:uh******** ******@TK2MSFTN GP09.phx.gbl ¤¤¼¶¼g...

On 2004-10-07, Agnes <ag***@dynamict ech.com.hk> wrote:

> my number is 100.1 , Now I only want to get 100 without any round up or
> round down function,
> Can anyone told me which function can do that ?
> Thanks
>
>

You'll want to look at the Int or the Fix function - depending on how
you want negative number handled. Here are the remarks from the
function reference:

http://msdn.microsoft.com/library/de...l/vafctint.asp

Remarks

Both the Int and Fix functions remove the fractional part of number and
return the resulting integer value.

The difference between Int and Fix functions is that if number is
negative, Int returns the first negative integer less than or equal to
number, whereas Fix returns the first negative integer greater than or
equal to number. For example, Int converts -8.4 to -9, and Fix converts
-8.4 to -8.

Fix(number) is equivalent to Sign(number) * Int(Abs(number) ).

HTH
--
Tom Shelton [MVP]