How do roundDown in VB

[vbakan]

I want to round the decimal number to a hole number and it should always be just the hole number with out decimals

eg 23.34526 = 23
0.563 = 0
23.7335 = 23

 

[Remou]

You can use Int:

Int(23.7335)

 

[pacmanUK]

Try something like this, the key part is WorksheetFunction, its 'calling' the standard Round function.

Dim myVal1 As Long
Dim myval2 As Integer

myVal1 = 23.5555

myval2 = Application.WorksheetFunction.Round(myVal1, 0)

MsgBox myval2

Cheers

 

[Remou]

pacmanUK
In my version, Round(23.7335)=24, not 23.

 

[pacmanUK]

Apologies, When sending the response I read the text in the question rather than the title...

vbakan - try

application.worksheetfunction.rounddown(myval1,0)

 

[Remou]

pacmanUK
What have you got against Int?

INT
Rounds a number down to the nearest integer.

Syntax

INT(number)

Number is the real number you want to round down to an integer.

You can use it in VBA, VB.Net, VBScript ...