By Neil Shorney, Director, Naturally Sales Ltd.
Excel has 3 options for rounding numbers: ROUND, ROUNDUP and ROUNDDOWN. Unlike rounding by formatting cells, the ROUND functions actually change the number in the cell rather than masking them with formatting.
They are all constructed in the same way: ROUND(cell_ref, number_of_decimal_places); i.e. =ROUND(A1,2) would round the value in cell A1 to 2 decimal places.
ROUND: This will round values to the nearest value, either up or down.
ROUNDUP: This will always round upwards.
ROUNDDOWN: This will always round downwards.
