I am trying to balance a checkbook and I have a total budget of $50,000 in A2. In column B are my expenses where I am using a running total. I need to have Excel pull the last value and subtract it from the total budget of $50,000. Initially, I used the MIN function and that works but not in the case of credit to my account. I need to get the last value in a column and subtract that from the total.
How do I do that?
How do I do that?