View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Phil
 
Posts: n/a
Default Rounding numbers

Hi,

After a calculation the result is 13.839. In excel it automatically rounds
to 13.84. I need to round down so that my result is 13.83. Is there anyway to
do this.

It for an accounting sheet and while a few pence wouldnt make a huge
difference I need to have the figures balancing.

Thanks in advance

--
Phil