Simple Rounding

[TheConeHead]

How do you round up in vbscript? I am looking to do what would be math.ceil() in javascript - you know rounding up no matter what the decimal is

thanks

 

[onpnt]

take a look at this thread
thread329-329218

also, if all you want to do is round something vbscript round function will do this fairly simple
syntax
Round(expression[, numdecimalplaces])
Dim var1, var2
var2 = 999.9
var1 = Round(var2, 0) ' var1 = 1000

You cannot mandate productivity, you must provide the tools to let people become their best.
-Steve Jobs
admin@onpntwebdesigns.com

 

[Guest_imported]

Hello,

Math.floor() <=== int()
Math.ceil() <=== custom_function_roundup
Math.ceil() <===> Math.floor()+1
hence
custom_function_roundup=int()+1

regards

 

[JohnYingling]

Always UP regardless of decimal? Use Int. Int always returns the &quot;first integer less than or equal to number&quot; so first make it negative, get INT value then reverse the sign again.

RoundUp = -Int(-dblIn)

From Docs
&quot;The difference between Int and Fix is that if number is negative, Int returns the first negative integer less than or equal to number, whereas Fix returns the first negative integer greater than or equal to number. For example, Int converts -8.4 to -9, and Fix converts -8.4 to -8.&quot;

http://www.VBResizer.com

Forms/Controls Resizing/Tabbing Control

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort Class in VB or VBScript

 

[Guest_imported]

Hello again.

Just to put the record straight. I've forgotten the obvious case where the number is already an integer, positive or negative.

Along this line, the custom_function_roundup() would be something like this:

Function custom_function_roundup(v)
If v<>Int(v) Then
custom_function_roundup=Int(v)+1
Else
custom_function_roundup=int(v)
End If
End Function

And of course the correspondance between Math.floor() and Math.ceil() contains this element as well.

regards

 

[Guest_imported]

Hello again.

Just to put the record straight. I've forgotten the obvious case where the number is already an integer, positive or negative.

Along this line, the custom_function_roundup() would be something like this:

Function custom_function_roundup(v)
If v<>Int(v) Then
custom_function_roundup=Int(v)+1
Else
custom_function_roundup=int(v)
End If
End Function

And of course the correspondance between Math.floor() and Math.ceil() contains this element as well.

regards

 

[Guest_imported]

Hello again.

Just to put the record straight. I've forgotten the obvious case where the number is already an integer, positive or negative.

Along this line, the custom_function_roundup() would be something like this:

Function custom_function_roundup(v)
If v<>Int(v) Then
custom_function_roundup=Int(v)+1
Else
custom_function_roundup=int(v)
End If
End Function

And of course the correspondance between Math.floor() and Math.ceil() contains this element as well.

regards

 

[Guest_imported]

Hello again.

Just to put the record straight. I've forgotten the obvious case where the number is already an integer, positive or negative.

Along this line, the custom_function_roundup() would be something like this:

Function custom_function_roundup(v)
If v<>Int(v) Then
custom_function_roundup=Int(v)+1
Else
custom_function_roundup=int(v)
End If
End Function

And of course the correspondance between Math.floor() and Math.ceil() contains this element as well.

regards

 

[Guest_imported]

Hello again.

Just to put the record straight. I've forgotten the obvious case where the number is already an integer, positive or negative.

Along this line, the custom_function_roundup() would be something like this:

Function custom_function_roundup(v)
If v<>Int(v) Then
custom_function_roundup=Int(v)+1
Else
custom_function_roundup=int(v)
End If
End Function

And of course the correspondance between Math.floor() and Math.ceil() contains this element as well.

regards

 

[Guest_imported]

Hello again.

Just to put the record straight. I've forgotten the obvious case where the number is already an integer, positive or negative.

Along this line, the custom_function_roundup() would be something like this:

Function custom_function_roundup(v)
If v<>Int(v) Then
custom_function_roundup=Int(v)+1
Else
custom_function_roundup=int(v)
End If
End Function

And of course the correspondance between Math.floor() and Math.ceil() contains this element as well.

regards

 

[Guest_imported]

Hello again.

Just to put the record straight. I've forgotten the obvious case where the number is already an integer, positive or negative.

Along this line, the custom_function_roundup() would be something like this:

Function custom_function_roundup(v)
If v<>Int(v) Then
custom_function_roundup=Int(v)+1
Else
custom_function_roundup=int(v)
End If
End Function

And of course the correspondance between Math.floor() and Math.ceil() contains this element as well.

regards

 

[Guest_imported]

Terribly embarrassed. Some error of transmission had led me to believe failures in the submitting process. Wish the moderator can delete redundant submission.

-visitji