Results 1 to 2 of 2
  1. #1
    kthompson
    Guest

    Rounding-calculations (2000 (9.0.2720))

    I am doing a calculation; column A is multiplied by a percentage (0.85) and results in an amount. The amounts are rounding so that the numbers do not add up to the amount of the total(sum) of the ending calculations. The total of column A is added and taking 85% of this amount does not give you the same amount that was added. How do I get it to round and calculate correctly?

  2. #2
    Star Lounger
    Join Date
    Dec 2000
    Location
    Tacoma, Washington, USA
    Posts
    68
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Rounding-calculations (2000 (9.0.2720))

    Go to Tools>Options Calculation and turn off Precision as displayed
    <IMG SRC=http://www.wopr.com/w3tuserpics/DougKlippert_sig.jpg>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •