<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> Thanks for your help - and sorry for taking so long to reply.<br>Your solution of:<br><br>Result = 46949.500 - mod("46949.500","100")<br>Result = 46949.500 - 495<br>Result = 46454.5<br><br>... doesn't seem to work - unless I don't understand how MOD works?<br><br>Let me try to restate my problem.<br><br>If I have a calculated number of 46949.5, I need it to round the nearest hundreds "after" dropping the decimal.<br><br>So the steps would proceed like this:<br>1. 46,949.5 becomes 46,949<br>2. 46,949 rounds to the nearest hundreds to become 46,900<br><br>Thanks for your help!<br><br>Matt Sherrill<br><div><br></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> Kenneth Brody <kenbrody@spamcop.net><br> <b><span style="font-weight: bold;">To:</span></b> Matt Sherrill <mmsv45@yahoo.com>; "filepro-list@lists.celestial.com" <filepro-list@lists.celestial.com> <br> <b><span style="font-weight: bold;">Sent:</span></b> Tuesday, November 19, 2013 12:38 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: Truncate<br> </font> </div> <div class="y_msg_container"><br>On 11/19/2013 11:24 AM, Matt Sherrill wrote:<br clear="none">> I’m sure this has come up before, but how do<br clear="none">> you truncate the decimals without FilePro rounding the number?<br
clear="none">><br clear="none">> I have 46949.500 that I need to round to the<br clear="none">> hundredth place (without the decimals). So I want my result to<br clear="none">> show "46,900", not "47,000" - which is what is happening now.<br clear="none"><br clear="none">Do you want it "without rounding the number" or "round to the hundredth place"?<br clear="none"><br clear="none">Assuming you mean that you want to "truncate" (to the "hundreds", not <br clear="none">"hundredth"), as implied by your subject, so that "46999.999" becomes <br clear="none">"46900" (your example would have the same result whether "truncate" or "round"):<br clear="none"><br clear="none"> result = number - mod(number,"100")<br clear="none"><br clear="none">If this is not what you meant, please post a better description of what you <div class="yqt9187433705" id="yqtfd58046"><br clear="none">need.</div><br clear="none"><br clear="none">-- <br
clear="none">Kenneth Brody<div class="yqt9187433705" id="yqtfd18024"><br clear="none"></div><br><br></div> </div> </div> </blockquote><div></div> </div></body></html>