I am putting together a financial spreadsheet for a club.
I thought I would add a small "Balance" helper column at column J. If the amounts are entered correctly a "B" will appear and if not an "N"
The formula in column Z15 to Z18 works well for my first three scenarios, but not in the fourth. I have tried pulling it apart where there appears to be a problem but nothing I do seems to work. Hopefully a new set of eyes can pick out what it is I am doing wrong.
If there is a more efficient way to write this formula please do tell me as I enjoy learning how to do things better.
Thank you
David
Bookmarks