Aug 21 2021 10:13 AM
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..
Aug 21 2021 10:42 AM
=SUM(INDEX([Balance],ROW()-2),-[@Debit],[@Credit])
Aug 21 2021 10:52 AM
Aug 21 2021 05:31 PM
Aug 21 2021 09:43 PM
SolutionAug 22 2021 09:03 AM
Aug 21 2021 09:43 PM
Solution