how to call out the "whole number" from "double"

[jasjas]

my Q is like this,

i want to design a calculation which use the number user enter to "/" by 100.
so , offcouse the result mayb in double or integer.
after that my calculation just wanna user the "whole number" of the result to calculate other things. can anyone help me? thks.

For eg: 9 / 2 = 4.5
and i just wanna take the number "4" to calculate other calculation.
so, how to call it out?

[Killer42]

i want to design a calculation which use the number user enter to "/" by 100.
so , offcouse the result mayb in double or integer.
after that my calculation just wanna user the "whole number" of the result to calculate other things. can anyone help me? thks.

For eg: 9 / 2 = 4.5
and i just wanna take the number "4" to calculate other calculation.
so, how to call it out?

You want the Int() function. For example, if you said Result = Int(9 / 2) you would end up with 4 in Result. You can get a similar effect by simply placing the value in a "whole number" type variable (Byte, Integer, Long etc.) except that then it will be rounded to the nearest whole number, not just "chopped". In other words, if you defined variable Result as an Integer and said Result = 9 / 2 you would get 5 in Result.

[jasjas]

so , if the result is 4.99, but i oso want to use the "4" only .so what should i do?
oso use int() ?

[hariharanmca]

my Q is like this,

i want to design a calculation which use the number user enter to "/" by 100.
so , offcouse the result mayb in double or integer.
after that my calculation just wanna user the "whole number" of the result to calculate other things. can anyone help me? thks.

For eg: 9 / 2 = 4.5
and i just wanna take the number "4" to calculate other calculation.
so, how to call it out?

Yha its simple,

Result = 9 \ 2


then u get 4

[Killer42]

Result = 9 \ 2
then u get 4

Like I said, assigning it to an Integer or Long variable will round up or down to the nearest whole number, while Int() function will always round down.

I've done a bit more checking. Unfortunately, it looks as though VB actually has the rounding rules slightly wrong. 4.5 should round up to 5, but doesn't. But if for example you place 4.51 in your variable, then it will round up to 5.

[kadghar]

Int() gives you back the lower integer, Fix() will give you the closest to zero..

i.e:

Int (4.99) = 4
Int ( - 3.2) = -4 (see, is the one below)

and

fix (4.99) = 4
fix( - 3.2) = -3 (i've found this one more useful)

And if you want a rounded result, use round and the number of decimals, use zero decimals to round to the closest integer.

[Killer42]

Thanks for the extra details, kadghar. Good head-up about the "nearer to zero" thing. I always forget about the effect of negative values.

However, using Round with 0 digits seems a bit superfluous, since it produces the same result as simply placing the value into an integer field. I suppose it depends on the circumstances whether it would be worth using or not.