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...
Sorry had a hiccup in the formula if you saw previous post.Here is the proper formula. You would need to put this formula in the 3rd row - 5th column. Since the 2nd row is a set amount , either negative or positive, the rest will follow using the formula. Just remember to mark the balance as a negative in the 2nd row if it starts with a Withdraw.
=IF(C3>0, C3+E2, E2-D3)
| Check Number | Name | Deposit | Withdraw | Balance |
| 1 | John | 500 | 500 | |
| 2 | Paul | 395.67 | 895.67 | |
| 3 | Verison | 200 | 695.67 | |
You could also add this to the 2nd row 5th column to start it but use the other formula to do the other calculations.
=IF(C2>0, C2,0-D2)