<div><div dir="auto">Doesn’t converting a ,.2 edit to a ,.0 edit do that automatically?</div><div dir="auto"><br></div><div dir="auto">Or, mid off the cents and do your test and if <= .50 mid off the $ part.</div><div dir="auto"><br></div><div dir="auto">Ken</div><br><div class="gmail_quote"><div>On Wed, 7 Mar 2018 at 10:57 am, Jose Lerebours via Filepro-list <<a href="mailto:filepro-list@lists.celestial.com">filepro-list@lists.celestial.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Is there not a ceiling function in filePro?<br>
<br>
One would think that you have it covered by simply reading your post. I<br>
mean, you even provide the [if] statements.<br>
<br>
if: frac(aa) gt ".50"<br>
'<a href="http://www.fileprotraining.com/WebHelp/Filepro/FRAC().htm" rel="noreferrer" target="_blank">http://www.fileprotraining.com/WebHelp/Filepro/FRAC().htm</a><br>
<br>
then: aa=int(aa)+"1";<br>
'<a href="http://www.fileprotraining.com/WebHelp/Filepro/INT().htm" rel="noreferrer" target="_blank">http://www.fileprotraining.com/WebHelp/Filepro/INT().htm</a><br>
<br>
<br>
I think ceiling may be a good option as well<br>
<br>
<a href="http://www.fileprotraining.com/WebHelp/Filepro/CEIL.htm" rel="noreferrer" target="_blank">http://www.fileprotraining.com/WebHelp/Filepro/CEIL.htm</a><br>
<br>
<br>
<br>
On 03/06/2018 06:47 PM, Wayne Smith via Filepro-list wrote:<br>
> I have a client that wants to take a whole 10,.2 number and if the cents<br>
> are ge .51 add a 1.00 to the total calculation.<br>
><br>
> if the cents are le .50 then take away cents and leave whole numbers.<br>
><br>
> I have tried some simple things ....in input.prc with no luck ...the list<br>
> is very slow ....one of you brains out there must know a simple math trick<br>
> in fp to solve this ....thanks ahead of time.<br>
><br>
> Windows 10, FP 5.8<br>
><br>
<br>
--<br>
Jose D. Lerebours<br>
954-559-7186<br>
<a href="https://www.cargosaas.com" rel="noreferrer" target="_blank">https://www.cargosaas.com</a><br>
<a href="http://www.ezbookeep.com" rel="noreferrer" target="_blank">http://www.ezbookeep.com</a><br>
<a href="http://www.ezdaemon.com" rel="noreferrer" target="_blank">http://www.ezdaemon.com</a><br>
<a href="http://www.fp2php.com" rel="noreferrer" target="_blank">http://www.fp2php.com</a><br>
<br>
_______________________________________________<br>
Filepro-list mailing list<br>
<a href="mailto:Filepro-list@lists.celestial.com" target="_blank">Filepro-list@lists.celestial.com</a><br>
Subscribe/Unsubscribe/Subscription Changes<br>
<a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" rel="noreferrer" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
</blockquote></div></div>