|
Look this is all very simple. An Integer value of anything is the value of whole numbers without the decimals. Microsoft, in the usual way, have tried to re-invent this basic concept. Personally I think it's a bug, but MickySoft say "no, we don't just truncate the decimals, we round down!". Which explains why negative numbers get screwed up. The usual MS mantra "It's not a bug it's a feature". They are wrong. All the products quoted by Peter are Microsoft products. IBM, for once, have followed the mathematically correct convention. They are correct according to 99.999% of the world's mathematicians. (The others obviously work for MickySoft). Why do you think Microsoft runs it's business on 400's? Alistair (MCSE) -----Original Message----- From: owner-rpg400-l@midrange.com [mailto:owner-rpg400-l@midrange.com]On Behalf Of Laskosky, Matt Sent: 02 March 2000 01:37 To: 'RPG400-L@midrange.com' Subject: RE: int(-8.9)=-9 or -8 And Perl returns -8, and according to my instructor this is correct since the function of %int(-8.9) is to return the integer value of the number w/o first rounding the number. Who's right? -----Original Message----- From: Peter Dow [mailto:pcdow@yahoo.com] Sent: Wednesday, March 01, 2000 4: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 +--- +--- | 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 +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
