Forum Discussion
Columns being done?
I'm new to Excel and the boss wanted this to be done:
Take five columns row by row
The first column contains a number of a check. This is what makes this row unique he says.
The next column has...
Without over thinking it and using IF formulas, the simplest answer is just basic + and - mathematics.
The first balance at E2 is simply the Deposit - Withdrawal
Then each subsequent balance is the Balance (row above) + Deposit (this row) - Withdrawal (this row). Copy the second formula down to the end of the data.
| A | B | C | D | E | ||
| 1 | Check Number | Name | Deposit | Withdrawal | Balance | Column E Formula |
| 2 | 00001 | John Revere | 500.00 | 500.00 | =C2-D2 | |
| 3 | 00002 | Paul Johnson | 395.67 | 895.67 | =E2+C3-D3 | |
| 4 | 00003 | Verizon | 200.00 | 695.67 | =E3+C4-D4 |