VB for Whole Number result after divide

[Rocky0201]

Hi...

I need to divide a value in an integer and receive the result as a whole number... not with the fraction.

If a divide 7 by 2, I need the result in my int to be 3 not 3.5. I tried using Rnd but got all fraction as a result.

Thanks.

 

[VoG]

Try like this

Sub test()
Dim x As Integer
x = Int(7 / 2)
MsgBox x
End Sub

 

[kpark91]

Just to elaborate on VoG's code..

He set 'x' as an integer variable so that 'x' can only take integer part of a result.
So, any values will become truncated when using Int method where it could be seen in the code.

So, x = Int (7/2)
would become x = Int (3.5)
Then Int will truncate everything after the decimal giving you
x = 3

 

[kpark91]

On the other hand, you would use float or double datatype (just like integers) when you want to store decimal places/fractions in a variable.

 

[Sektor]

Sub G()
    Const i As Integer = 7
    MsgBox Fix(i / 2)
End Sub

 

[Rocky0201]

Thank you very much folks... It's exactly what I need...

 

[pgc01]

Hi

Remark: check also the integer division operator "\"

Ex.:

Sub Test()
    Const i As Long = 26
    MsgBox i \ 7
End Sub