rounding

  • Thread starter Thread starter Carla
  • Start date Start date
C

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?
 
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)
 
Back
Top