Richard: I have a simple problem with Excel. I am running a ledger for the Veterans and have my funds either added or subtracting from the bank (single accounting procedure); I am using a sum total for all entries, i.e. (=sum(F5:N5) all the way down on the bank column. However, at the bottom where I have my totals - income and disbursements, I take the total I start with; add my income; subtract my disbursements; and the total is adding my disbursements rather than subtracting them. My formula is =E4+E59-E60. This has happened many times where the subtractions are being added rather than subtracted. Everything else is fine? I can send a copy of my ledger but I can't do it in this blog?
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.