Visual Basic Code , VB.NET Code, VB Code
  Home   :  Code   :  Forums   :  Submit   :  Mailing List   :  About   :  Contact


Function Rounddown in excel how above in vb


Function Rounddown in excel how above in vb

Author
Message
zikri_aushaf@yahoo.co.id
zikri_aushaf@yahoo.co.id
Forum God
Forum God (351 reputation)Forum God (351 reputation)Forum God (351 reputation)Forum God (351 reputation)Forum God (351 reputation)Forum God (351 reputation)Forum God (351 reputation)Forum God (351 reputation)Forum God (351 reputation)

Group: Forum Members
Posts: 1, Visits: 1
Hello

How to Rounddown Example 1.250.525 rounddown to 1.250.000, if in excel it can automatically

but how above in vb please tell me

Thank's

VB BEGINER

macroman
macroman
Forum God
Forum God (11K reputation)Forum God (11K reputation)Forum God (11K reputation)Forum God (11K reputation)Forum God (11K reputation)Forum God (11K reputation)Forum God (11K reputation)Forum God (11K reputation)Forum God (11K reputation)

Group: Forum Members
Posts: 71, Visits: 264
The Int or Fix functions will do that.

debug.Print int(1250.525)
 1250

debug.Print fix(1250.525)
 1250

fix will convert positive or negative numbers toward zero; int will convert downward only.

debug.Print fix(-1250.525)
-1250

debug.Print int(-1250.525)
-1251

GO


Similar Topics


Reading This Topic


Login
Existing Account
Email Address:


Password:


Social Logins

Select a Forum....

















A1VBCode Forums


Search