Post your point formulas
In E1: ?
In E2: ?
E2 is then copied down?
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik
---
"teprps - ko" wrote
This works only if both the debit and credit cells contain data. However,
in
an accounting entry one row has a debit entry - leaving a blank credit
cell.
The next row might have a credit entry - leaving the debit cell blank.
Therefore, with your formula when it sees a blank cell it ignores the data
cell and the balance cell is blank. I need it to work like this:
i.e. A1 = 4, C1 = 0, E1 = 4
A2 = 6, C2 = 0, E2 = 10
A3 = 0, C3 = 1, E3 = 11
Row 4 is blank
A5 = 0, C5 = 3, E5 = 14

Any other ideas???