Easier answer? Length in feet given desired length L in whole inches (i.e. rounded up inches!) is:
(INT((L+5)/6)/2) = Feet E.g. (INT((91+5)/6)/2) = (INT(96/6)/2) = (INT(16)/2) = 16/2 = 8 ft E.g. 7'5"=89"; int(89+5/6)/2 = int(15.667)/2 = 7.5 ft. Regards, Stephen Markson ForenSys The Forensic Systems Group www.ForensicSystemsGroup.com 416 482 2140 > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Victor > Timmons > Sent: January 23, 2003 6:15 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Rounding Up Answer > > Problem > Customer Orders 1 piece of 101' Lumber > RBase must remove from inventory then next higher 1/2 foot > > SET VAR vTrQty1 REAL = 1 --(the number of pieces) > SET VAR vTrSize1 REAL = 101 --(the size of the piece) > > SET VAR vQ1 REAL = (AINT((.vTrQty1 * (.vTrSize1 / 12 ))+.99)) > SET VAR vQ1A REAL = (.vTrQty1 * (.vTrSize1 / 12 )) > SET VAR vQ1B REAL = (.vQ1 - .vQ1A) > IF .vQ1B <= .5 THEN > SET VAR vQ1C = .vQ1 > ELSE > SET VAR vQ1C = (.vQ1 - .5) > ENDIF > > The answer is the next highest 1/2 foot. In this case 8.5 feet
