Round() Question

[michaelslamet]

$a = "12.3456789"
$b = "12.3499999"

MsgBox(0,"",Round($a,5))
MsgBox(0,"",Round($b,5))

 

First MsgBox will display "12.34568"

Second MsgBox will display "12.35"

I would like the second MsgBox display "12.35000", so I want the decimal digits is always 5.

Is there any function I should use instead of Round() for this purpose?

[jchd]

Round then StringFormat() will do. But it is an uncommon operation to "adjust" values this way.

[iamtheky]

This could very well be incorrect

$a = number("12.3456789")
$b = number("12.3499999")

MsgBox(0,"", stringformat('%.5f' , round($a , 5)))
MsgBox(0,"", stringformat('%.5f' , round($b , 5)))

[Bowmore]

@Bothouse

What you posted works OK but there is no need to use Round() at all as specifying the number of decimal plcace in StringFormat() causes StringFormat to do the rounding for you.

$a = "12.3456789"
$b = "12.3499999"

;5 decimal places with trailing 0s
MsgBox(0,"",StringFormat("%.5f",$a))
MsgBox(0,"",StringFormat("%.5f",$b))

$a = "12.3456789"
$b = "123.3499999"
;5 decimal places with trailing 0s and 5 digits before the decimal point with leading 0
MsgBox(0,"",StringFormat("%011.5f",$a))
MsgBox(0,"",StringFormat("%011.5f",$b))

 

[jchd]

Sorry, I misread the value. So no Round is superfluous.

[michaelslamet]

Thank you jchd, boththose and Bowmore for your help

StringFormat() without Round() working great!