Forum Discussion

Alisa Drury's avatar
Alisa Drury
Copper Contributor
Sep 16, 2018

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

Resources