Forum Discussion
Solved
Simple check register formula problem
I'm trying to set up a simple check register spreadsheet. I have created the table and it's formatted. My issue comes when I write the formula to make the balance a 'plus' or 'minus' depending on whether the amount is in the 'debit' column or the 'credit' column. Apparently, I've got something incorrect in the 2nd part of the formula because it works until it gets to a 'credit' cell -
Here's an example:
=IF(F3>=0,H2-[@Debit],H2+[@Credit])
I appreciate any expertise on my not-so-great at formulas..
5 Replies
- Still looking for a hint on this formula...
- It works!! I was making it a big deal when it was really very simple.. Thank you.
=SUM(INDEX([Balance],ROW()-2),-[@Debit],[@Credit])- OK, error msg says it's "missing an opening or closing parentheses" I added a second ")" at the end... no joy. ???
