Can someone please tell me how to write a formula for the cells in the balance column to deduct debits and add credits?
Example: Col A Debit, Col B Credit, Col C Balance
I want a formula in Col C to subtract Col A and add Col B.
Thank you.
Can someone please tell me how to write a formula for the cells in the balance column to deduct debits and add credits?
Example: Col A Debit, Col B Credit, Col C Balance
I want a formula in Col C to subtract Col A and add Col B.
Thank you.
If I understood you correctly then the formula is strait forward.
In cell C1 enter:
=B1 - A1
and so on for the rest of the cells.
Welcome to: http://www.exceldigest.com/myblog/
"Excel help for the rest of us"
Type Check Register in the help search bar in Excel. There's a groovy template to download for free. I just looked that up myself earlier today. :-)
there is a free Excel check register at http://1ceware.webs.com/downloads.htm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks