...

View Full Version : ignore decimal points



esthera
01-30-2005, 01:23 PM
Is there a function that can take a number and return it without the decimal points.

for example if the number is 3.5 I want it to return 3. If I do cint(3.5) it will return 4 which is not what I want.

glenngv
01-31-2005, 02:50 AM
Use Fix(N)

esthera
01-31-2005, 06:23 AM
what's the syntax? I never saw this function before?

fractalvibes
01-31-2005, 06:58 AM
Fix(3.5) returns 3

See : http://www.devguru.com/Technologies/vbscript/quickref/fix.html
for potential rounding issues.

fv



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum