Rounding numbers
=INT(13.839*100)/100
Or if your value was in a cell, e.g. A1:
=INT(A1*100)/100
--
Regards,
Dave
"Phil" wrote:
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
|