Excel calculations round off error

[jimbo_jones]

Hello All,

Today I was using excel to do some expense calcs and there was some round off error when I calculate percentages.

If I multiply a number by 0.07 it will round down, but I want it to round up. Is there a way to control the rounding? Thanks

[Nick Hodge]

Jimbo

Look at the formulas ROUNDUP, ROUNDDOWN in help

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]HIS


"jimbo_jones" <[email protected]>
wrote in message
news:[email protected]...
>
> Hello All,
>
> Today I was using excel to do some expense calcs and there was some
> round off error when I calculate percentages.
>
> If I multiply a number by 0.07 it will round down, but I want it to
> round up. Is there a way to control the rounding? Thanks
>
>
> --
> jimbo_jones
> ------------------------------------------------------------------------
> jimbo_jones's Profile:
> http://www.excelforum.com/member.php...o&userid=27244
> View this thread: http://www.excelforum.com/showthread...hreadid=482023
>

[JE McGimpsey]

Check out ROUNDUP() in XL Help.

In article <[email protected]>,
jimbo_jones <[email protected]>
wrote:

> Hello All,
>
> Today I was using excel to do some expense calcs and there was some
> round off error when I calculate percentages.
>
> If I multiply a number by 0.07 it will round down, but I want it to
> round up. Is there a way to control the rounding? Thanks