Results 1 to 2 of 2
  1. #1

    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
    Tacoma, Washington, USA
    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=>

Posting Permissions

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