Victor, Add .999, and take the INT or AINT portion:
(AINT(91 / 12) + .999)) Bill On Thu, 23 Jan 2003 12:00:28 -0800, Victor Timmons wrote: >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 >
