Maybe something like this:
=IF(COUNT(A2,C2)<2,"",<yourformula)
which returns "blanks", ie "" unless cols A and C contain numbers
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:62
xdemechanik
---
"teprps - ko" wrote:
I have debits (column a) and credits (column c) with a running balance
(column e). How do I leave a blank space in the running balance when there
is a blank row between entries? Note: some entries use multiple consecutive
rows.