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.