|
kind of like Accesses CEILING Command
----- Original Message -----
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
|