RE: int(-8.9)=-9 or -8

["McCallion, Martin" <MccalliM@xxxxxxxxxxxxxxxx>]

>By Excel functions, int(-8.1)=-9. And %Int in RPGiv is -8. 
>
>How can I get -9 same as an Excel function by RPG iv?
>Is which result(-9 or -8) normal for you ?
>

Excel is wrong, based on what I learned in school (round down if less
than five after the decimal, up if greater; if equal I seem to recall
that you went to the nearest even number, which seems a bit arbitrary,
but you have to do something).  There was an article about this in PC
Pro recently. Excel and VBA are inconsistent, if I remember correctly.
So if you do that formula in Excel itself you get the result you see,
but if you use the int() function in a VBA macro you get a result that
matches RPG.

Having said that, I see that the value in your subject line doesn't
match that in the body.  My comments above assume that you meant -8.1.
If you meant -8.9, then RPG and VBA are wrong, IMHO.  I know which way
I'm betting.

Cheers,

Martin.

--                                                                     
Martin McCallion                 
Midas-Kapiti International
Work:  mccallim@midas-kapiti.com
Home: martin.mccallion@ukonline.co.uk

Apologies for the length of this sig, but company policy says:
This email message is intended for the named recipient only.  It may be
privileged and/or confidential.  If you are not the intended named
recipient of this email then you should not copy it or use it for any
purpose, nor disclose its contents to any other person.  You should
contact Midas-Kapiti International as shown below so that we can take
appropriate action at no cost to yourself.

Midas-Kapiti International Ltd, 1 St George's Road, Wimbledon, London,
SW19 4DR, UK
Email: Postmaster@midas-kapiti.com Tel: +44 (0)208 879 1188 Fax: +44
(0)208 947 3373
Midas-Kapiti International Ltd is registered in England and Wales under
company no. 971479

.:. 
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---