• Same Numbers, Differerent Totals

    Author
    Topic
    #351741

    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.

    Viewing 0 reply threads
    Author
    Replies
    • #509975

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

      • #509976

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

    Viewing 0 reply threads
    Reply To: Same Numbers, Differerent Totals

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: