<html><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:8pt">Ken,<br><br>Thank you so much for your help. Your solution will work great!<br><br>Issue: Rounding with truncating the decimal.<br><br>Thanks!<br><br>Matt Sherrill<br><div></div><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; margin-top: 5px; padding-left: 5px;"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 8pt;"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 12pt;"> <div dir="ltr"> <hr size="1"> <font face="Arial" size="2"> <b><span style="font-weight:bold;">From:</span></b> ken white <kenwhite@verizon.net><br> <b><span style="font-weight: bold;">To:</span></b> Matt Sherrill <mmsv45@yahoo.com> <br> <b><span
style="font-weight: bold;">Sent:</span></b> Wednesday, December 11, 2013 4:06 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: Truncate<br> </font> </div> <div class="y_msg_container"><br>for clarity:<br clear="none">(104053.14 + 130939.172) = 234992.312 'number to round<br clear="none">the result should be 235000<br clear="none"><br clear="none">But what if 234942.312 was the number to round to the nearest hundreds?<br clear="none">It should show rounded as 234900<br clear="none"><br clear="none">I believe the code provided does what you want.<br clear="none">::na(12,.5) = "234992.312"<br clear="none">::nn(8,.0)=int(na) '234992:<br clear="none">::no(8,.0)=mod(nn,"100"): '92<br clear="none">::nn=nn-no: '234900<br clear="none">:no ge "50":nn=nn+"100": '+100<br clear="none">::msgbox nn: '235000<br clear="none">::end:<br clear="none"><br clear="none">::na(12,.5) = "234942.312"<br
clear="none">::nn(8,.0)=int(na) '234942:<br clear="none">::no(8,.0)=mod(nn,"100"): '42<br clear="none">::nn=nn-no: '234900<br clear="none">:no ge "50":nn=nn+"100": '+0<br clear="none">::msgbox nn: '234900<div class="yqt5099973288" id="yqtfd82995"><br clear="none">::end:</div><br clear="none"><br clear="none">wu(8,.0) = nn<div class="yqt5099973288" id="yqtfd18878"><br clear="none"></div><br><br></div> </div> </div> </blockquote><div></div> </div></body></html>