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

=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

=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

Thanks for the help, it works well!
--
Phil


"Bob Phillips" wrote:

=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