At 12:00 PM 1/23/2003 -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
Victor,
Look into the BRND, also called Banker's Rounding Function!
For complete details and examples:
http://www.RSyntax.com
Your favorite site!. How did you missed BRND on that site?
Have Fun!
Very Best Regards,
Razzak.
