Round up down or anywhere

[Guest]

I have to fill in a form for the dreaded tax office. Now this form needs to
be correct only to 2 decimal places, therefore discarding any number after
that without rounding the thrid decimal place up. Is there are format to use
on the whole work book? Also any calculations done with that figure should
only use those 2 decimal places but Excell keeps using the whole figure, can
this be stopped also?

 

[Bill Ridgeway]

It used to be the case that income was always rounded down to the nearest £
and outgoings and allowances was always rounded up to the nearest £. The
advantage was marginal but gives a satisfaction of having won something from
the tax office. If this is still the case (read the small print) you don't
want go rounding everything the same way. This applies only to the amount
displayed on the screen. Internally, Excel is accurate to a number of
decimal places.

The formula are -
=ROUNDUP(A1,2)
=ROUNDDOWN(A1,2)

Regards.

Bill Ridgeway
Computer Solutions