Several rounding and truncating functions are shown in this tutorial. The functions include: Round, Round Up, Round Down, Truncate, Integer, Even and Odd rounding. The functions can round to user specified number of decimal places.

Apache OpenOffice is a free download at www.openoffice.org

Spreadsheet Downloads
Calc 4 Tutorial 7 Start.ods
Calc 4 Tutorial 7 Finish.ods