Microsoft Office Tutorials and References
In Depth Information
Calculating the quantities
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
I do like a well-rounded holiday!