Running Total and 0's

  • Thread starter Thread starter xQQsME
  • Start date Start date
X

xQQsME

Hi,
In Column G, I have a running total scenario derived from
columns D and E.
In Column G I have the formula (copied down) and is
=IF(D5>0,(G4-D5),IF(E5>0,(G4+E5),"")).
My problem is that if there is no value (or a 0) in a row
the #Value error occurs.
Is there a better formula that will hold a 0 and carry on
with the running total?

T.I.A.
 
Solved it!!! by adding two (2) more conditions for IF D
and E =0 then 0+G. Its cumbersome but works, if there is a
simpler solution I'd appreciate it.
 
Back
Top