round off numbers?

Replies to This Discussion

Permalink Reply by Aleksandar Dimitrov on January 3, 2013 at 10:16am

thanks also from my side :)

Permalink Reply by Eric Werner on March 30, 2010 at 8:48am

Hi Chris,

You can do this easily by making a function that formats doubles

Private Sub RunScript(ByVal x As Double, ByRef A As Object, ByRef B As Object)
' You can do it by chopping the numbers off like below
A = Format(x, "#.0")

' or by rounding the numbers like below..
B = Math.Round(x, 3, MidpointRounding.AwayFromZero)

End Sub

Permalink Reply by Chris on March 30, 2010 at 9:44am

thanks Eric excellent

Permalink Reply by Michal Dengusiak on April 16, 2014 at 12:48am

Maybe I ask basic but how do I find what is parameter name?

this function does not work as can not recognize Num...Panel does not work as well...

Permalink Reply by Pieter Segeren on April 16, 2014 at 1:14am

Hi Michal, all expressions now use x as variable, so Round(x,3) is what you want.

Permalink Reply by alek on June 6, 2014 at 10:37am

Hi all

Does anyone knows how to get the decimals rounded by, say, 0.05?

for these sort of situations:

101.54 to 101.55

10.98   to 11.00

Permalink Reply by Danny Boyes on June 6, 2014 at 5:27pm

It's the same answer as outlined above.

Number to round --> (A)Division

0.05 --> (B)Division

#where 0.05 is the amount to round to

Division --> Round

Round(N) --> (A)Multiplication

0.05 --> (B)Multiplication

Multiplication --> Results

• ‹ Previous
• 1
• 2
• Next ›
• Page