Forum Discussion
Alisa Drury
Sep 16, 2018Copper Contributor
Excel formatting issue
I have been using the Check Register template for two years and all of a sudden when I enter a row, the formatting isn't there. Balance field on the inserted row says 0.00 (which it never does) and if I enter an amount (deposit, or debit) it doesn't calculate to the balance column.
This is the formatting for the Balance field:
=IF(COUNT(tblData[@[DEBIT (-)]:[CREDIT (+)]])=0,"",-SUM(INDEX([DEBIT (-)],1):[@[DEBIT (-)]])+SUM(INDEX([CREDIT (+)],1):[@[CREDIT (+)]]))
Thank you in advance for your help.
Alisa
No RepliesBe the first to reply