I have a named table on a worksheet that I am trying to use to track weekly bank transactions, much like a checkbook register. I am using the following formula to determine if the row contains a deposit or withdrawl and then this SHOULD add or subtract for the value above based on the conditions. However, when I enter the formula I get an error stating that there is an error in your formula and nothing more helpful than that.
Formula:Please Login or Register to view this content.
My table is as follows:
trans.PNG
I have a similar formula on a working transaction log that looks exactly like this, with the exception of the named table, that formula is below.
Formula:Please Login or Register to view this content.
that table looks like this:
bnk.PNG
Can anyone see the error in the first formula, as this has me stumped??
Thank you
Bookmarks