<div>
Sometimes the answer is so easy.....
</div>


<div>
Have fun....<br />
<br />
Try this:<br />
<br />
MsgBox Round(1 / 2, 0)<br />
MsgBox Round(3 / 2, 0)<br />
MsgBox Round(5 / 2, 0)<br />
MsgBox Round(7 / 2, 0)<br />
MsgBox Round(9 / 2, 0)<br />
<br />
<br />
Result: 0, 2, 2, 4, 4<br />
<br />
Great eh?<br />
<br />
See also:<br />
<a href="http://oldlook.experts-exchange.com/bin/Q.10113932" rel="ugc nofollow">http://oldlook.experts-exchange.com/bin/Q.10113932</a><br />

</div>


Have fun....

Try this:

MsgBox Round(1 / 2, 0)
MsgBox Round(3 / 2, 0)
MsgBox Round(5 / 2, 0)
MsgBox Round(7 / 2, 0)
MsgBox Round(9 / 2, 0)


Result: 0, 2, 2, 4, 4

Great eh?

See also:
http://oldlook.experts-exchange.com/bin/Q.10113932 [http://oldlook.experts-exchange.com/bin/Q.10113932]


<div>
<div class="content wysiwyg-content">
Dim A,B,C as double<br />
B = 5000<br />
C = 400000 &nbsp; &nbsp;<br />
&nbsp;<br />
<br />
A= Round(B/ C,3)<br />
A = .0125 &nbsp;When I round it three places though, I get .012 &nbsp;What I want is .013 &nbsp;When I use this line of code instead <br />
A= Round(CSng(B/ C,3) I get the desired result of A = .013<br />
<br />
Is this the correct way to get the numbers to round up?<br />

</div>
</div>


Dim A,B,C as double
B = 5000
C = 400000    
 

A= Round(B/ C,3)
A = .0125  When I round it three places though, I get .012  What I want is .013  When I use this line of code instead 
A= Round(CSng(B/ C,3) I get the desired result of A = .013

Is this the correct way to get the numbers to round up?


rounding

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.