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

To help clarify somethings, below is the help text from Excel.  It clearly
gives an example with a negative number and what it does.  Some people
seem to be confusing int with rounding.  Taking the int of something
should give the integer portion on the number, no rounding should be
done.  And so the -8 would be the correct answer unless you are some
programmer at Microsoft who wants to screw with the world! ;-)

-- Scott
------------------------------------------------------------------------
Int Function, Fix Function:

Returns the integer portion of a number.

Syntax

Int(number)
Fix(number)

Elements

The number argument can be any valid numeric expression.  If number contains
no valid data, Null is returned.

Remarks

Both Int and Fix remove the fractional part of number and return the resulting
integer value.
The difference between Int and Fix is that if number is negative, Int returns
the first negative integer less than or equal to number, whereas Fix returns
the first negative integer greater than or equal to number.  For example, Int
converts -8.4 to -9, and Fix converts -8.4 to -8.
Fix(number) is equivalent to:

Sgn(number) * Int(Abs(number))

------------------------------------------------------------------------
Jim Langston wrote:
> 
> By standard definition RPG is doing it right.  The Int function
> (integer) takes the integer portion of a number and drops the
> fraction.  The Integer of -8.1 is indeed -8, not -9.  I think you'll
> find if you take the Int of 8.1 in Excel it will come out 8, not 9,
> unless Excel automatically rounds up.
> 
> Regards,
> 
> Jim Langston
> 
> "Tadashi K." wrote:
> 
> > Hi, all
> >
> > 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 ?
> >
> > Tadashi
> >
> > /* ---------------------------------------------------------*/
> >                        Tadashi Kakefuda
> >  The Internet Mail Address ; tadashii@tk.airnet.ne.jp
> >    * Official site ; http://www2c.airnet.ne.jp/as400/
> >  /*----------------------------------------------------------*/
+---
| 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
+---