SROUND A Spread formula that allows you to scientifically round values.
SROUND(Cell Reference/Value, Decimal Places)
Cell Reference/Value: The specifies the value to round.
Decimal Places: Number indicating how many places to the right of the decimal are included in the rounding.
Scientific Rounding: When the fractional part is exactly 0.5, the function always rounds it to the nearest even number. For example, 0.5 rounds to 0, and 1.5 rounds to 2. Normal rounding rounds digits 1,2,3, and 4 down. Rounds digits 5,6,7,8, and 9 up.
You can only display up to 10 significant digits using this function.
In Spread Reports if you want to use normal rounding, simply set the decimal places by using the Increase/Decrease decimal buttons or use Format, Cell.
See Scientific vs Normal rounding for a table showing the key differences between the rounding techinques.
See SROUNDZ for rounding of values with qualifiers (i.e. <2).
=SROUND(1.2250,2) returns 1.22
=SROUND(G8,1) returns 1.6 (where the cell G8 = 1.65)
=SROUND(1.45,1) returns 1.4
=sround(GAVG(1,1,"M"),1) 3.1 (Where the GAVG Function returned 3.106)
=SROUNDZ("<2.5", 0) <2
=SROUNDZ(GAVGZ(1,1,"M",1, 2),1) <3.1 (where GAVGZ returns "<3.11")