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

However if you use the  trunc  function in excel, it should just drop the
fraction/decimal position...

tim

> -----Original Message-----
> From: Peter Dow [SMTP:pcdow@yahoo.com]
> Sent: Wednesday, March 01, 2000 1:53 PM
> To:   RPG400-L@midrange.com
> 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
+---