Rounding numbers
=rounddown(a1,2)
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Phil" wrote in message
...
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
|