rounding

[Carla]

I am working in excel 2002 and want to round my
calculations to a corner balance. My addidtion funciton is
rounding down while my other calculation(multiplication)
is rounding up. How can I control this?

 

[Bob Phillips]

Round it yourself

=ROUND(A1,2) will round to 2 dec places

=ROUNDUP(A1,2) rounds up to 3 dec places, and

=ROUNDDOWN(A1,2) ... well you know the rest.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)