Round Function In Numbers

HI Nick,

The function you are looking for is MROUND (round to a specified multiple)

Here are examples sing your two requests:

In the upper version, the factor has been set to 0.5; in the second, it's been set to 0.1. Otherwise, both formulas are the same.

Geting Numbers ito include the trailing zero is handled in the (Cell) Format Inspector by setting the number of decimal places to be displayed to 2:

Regards,

Barry

Lets say 23.36 is in cell B2.

For the first one if all numbers will be positive,

=CEILING(B2, 0.5) will round away from 0 the next 0.5

=MROUND(B2, 0.5) will round to nearest 0.5

If you might have negative numbers,

=CEILING(B2, 0.5*sign(B2)) will round away from 0 next 0.5

=MROUND(B2, 0.5*sign(B2)) will round to nearest 0.5

For the second one I am assuming you are rounding to nearest tenth.

=ROUND(B2, 1)

And to round toward 0 there is the FLOOR function.

SG