[Don Walke]

This one got me thinking about the “round” function. Does anyone know the proper syntax to use and can you round up and round down? If you are taking off quantities of ceiling tile for instance, any measurement over an increment of 4 feet in the long direction would require an additional tile. You could take a measurement, divide by 4,create a column that would take the answer, round it up and that would give you the number of tiles. If you wanted to price by SF, just create a column that would multiply the number of tile by 4.

Update: Just figured that the “ceiling” function rounds up “floor” function rounds down. Who woulda thunkit.