Due to an accounting error in my personal checkbook (which has been ongoing for over a year), I am finally attempting to find the error. As such, I am using Lotus 1,2.3 to copy all entries in my check book ( in effect mirroring my check register) and then to proof it against my bank monthly statements. In order to “speed up” the process, I have been using the @SUM button, which has functioned quite well until about half way through the entries.
In several instances there have been negative results so that the balance appears as ($xxx.xx). The second (payment/debit) entry, when attempting to subtract this from the above balance, results in a positive/added sum. For the purpose of clarity, I have cut and pasted below that which actually appears.
Col. A Col..B Col. C
Column A is the payment/debit amount.
Column B is the deposit/credit amount.
Column C is the balance amount.
My question is: By using the @sum button how can I obtain the correct balance amount (preferably with the parenthesis and dollar sign/$ ?
Second part of the question: Inasmuch as Col. A is entered and appears as a positive/+ amount, would it be best to have a minus sign (-) preceding the entered amount, or perhaps parenthesis? If so, what would be the most simplistic way to include the sign on the several hundred entries (which I really would not want to do by having to start all over again?
Needless to say, an early reply to my email address would be most gratefully appreciated. Thank you. DP