basic excel training - Rounding numbers

Hi Ruth

The function that will help you is the ceiling and floor, the ceiling function will round up and the floor function will round down.

An example of this is:
=CEILING(3679,1000)

This example shows that you will be rounding 3679 upwards and you will rounding to the nearest thousand. The first number within the brackets is the number you want to round and the second number is the unit you want to round up/down too.

Hope this helps

David