Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Feb 2005
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Same Numbers, Differerent Totals

    I use Excel for client billing, creating both an invoice sheet and a statement sheet for each account. Each sheet is setup differently but use the same exact numbers. Thus, they should yield the same totals, which I use as a system of checks and balances.

    Yet sometimes I get totals that differ by one cent. It seems like this might be a "rounding off" issue. In "cells formatting" I use currency and 2 digits.

    Any ideas? Thanks for your help.

  2. #2
    denlow
    Guest

    Re: Same Numbers, Differerent Totals

    I think you're right about rounding. Formatting the cell to two places doesn't round the content. If you want each number rounded you'll need to apply the ROUND function.

  3. #3
    New Lounger
    Join Date
    Feb 2005
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Same Numbers, Differerent Totals

    Thank you for your post. Since it's currency, why would I need to round anything?

  4. #4
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Cairns, Queensland, Australia
    Posts
    885
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Same Numbers, Differerent Totals

    The currency option is a display format only, it does not apply the rounding option to the cell/s.
    Granville

Posting Permissions

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