Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Boston, Massachusetts, USA
    Posts
    167
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Incorrect Result of Formula (Excel 97)

    I cannot, for the life of me, figure out why the column I've highlighted in green on the attachment is returning a result of 65,820.00 instead of the correct result of 65,825.26. It's not a rounding issue. Could I have messed up my default calculation settings and not known it?
    thanks
    christine

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Incorrect Result of Formula (Excel 97)

    It is a rounding issue. Cell C7 is formatted to display 2 decimals, so it shows 59.27. But the actual outcome of the formula in the cell is 59.2652620205294. If you multiply that by 1110.60, you get exactly 65,820. If you need to use 59.27 instead of 59.2652620205294, you must use ROUND in the formula for C7.

  3. #3
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Boston, Massachusetts, USA
    Posts
    167
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Incorrect Result of Formula (Excel 97)

    Well, duh!!!!!! I knew that!!!!!
    I guess I had a quick brain lapse! Thanks again!
    thanks
    christine

Posting Permissions

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