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

Checking MSDN it reports that command INT removes the fractional part of a
number  and returns  the resulting integer value.
BUT..
It also states that

INT(number)
If number is negative , INT returns the first negative integer less than or
equal to number.  For example, INT converts -8.4 to -9.

Well, thats where microsoft stands on the int function.  Can you find a
description in the ILE/RPG manual for this?  What does it say?






"Peter Dow" <pcdow@yahoo.com> on 02/03/2000 07:52:51

Please respond to RPG400-L@midrange.com

To:   RPG400-L@midrange.com
cc:    (bcc: RICK A PEZZIMENTI/DIAU)

Subject:  Re: int(-8.9)=-9 or -8




A quick check shows that
MS-DOS Qbasic 1.0 says int(-8.1) = -9
MS QuickBasic 4.5 says int(-8.1) = -9
VB 6.0 says int(-8.1) = -9
VBA with Excel 97 also shows int(-8.1) = -9
So these releases are at least consistent, if not correct.
If you want RPG IV to match Excel, you've got a problem!
Peter Dow
Dow Software Services, Inc.
909 425-0194 voice
909 425-0196 fax
----- Original Message -----
From: McCallion, Martin <MccalliM@Midas-Kapiti.com>
To: <RPG400-L@midrange.com>
Sent: Wednesday, March 01, 2000 6:14 AM
Subject: RE: int(-8.9)=-9 or -8

> >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
> +---

__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com
+---
| 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
+---






+---
| 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
+---