Microsoft Office Tutorials and References

In Depth Information

**Calculating the quantities**

Rounding numbers

There is a problem with this spreadsheet, and it will only come to light when you

have an odd holiday. By that, I mean a holiday with an odd number of days, not a

short break dressing as a brontosaurus and making triﬂ es. Each to his own.

If you go away for seven days and the car hire is calculated as half your holiday,

the budget will calculate the costs of hiring a car based on 3.5 days. Most hire

ﬁ rms only hire a car for a whole day at a time. To make sure our budget reﬂ ects

this, we can ask Excel to round up our ﬁ gure for car hire days.

To do that, we use a function called ROUNDUP. We need to tell the function

what number we want to round, and how many decimal places we want the result

to have. If we say we don’t want any decimal places, we’ll get the next largest

whole number, which is exactly what we need.

To use the ROUNDUP function, we wrap it around our formula for days of car

hire. The formula so far is:

=B1 / 2

To make its result always round up to the next whole number, change the formula to:

=ROUNDUP(B1 / 2, 0)

In English, this means, make the cell equal to a rounding up of the contents of cell

B1 divided by two, and don’t use any decimal places in the rounding.

Because you’ve based the petrol budget on the number of car hire days, you only

need to do this rounding for the car hire days. The number of days of petrol budget

automatically reﬂ ects your car hire days.

There is also a ROUNDDOWN function which works in the same way, but will

always round down. There is a ROUND function too, which rounds up or down

to the nearest number. A number that’s exactly in the middle (like 3.5) will be

rounded up.

I do like a well-rounded holiday!