I believe that has been referred to as the "covered quotient". When you have integers, like your 91 and 12 below, compute
(91 + 11)/12 where the 11 is one less than the divisor. Bill Cook Kent WA USA ----- Original Message ----- From: "Victor Timmons" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, January 23, 2003 12:00 PM Subject: [RBASE-L] - Rounding up What im tring to do is alway ROUND UP (not down) to the nearest half foot. Say you need 1 91" piece of lumber i need to releave 8' from inventory not 7.6' 1 * (91 / 12) = 7.583' Ordered 8' needs to releaved from inventory vTrTotal1 =(ROUND((.vTrQty1 * (.vTrSize1 / 12 )),1)) doesnt work because it can round up and down
