Formula Help (Frank?)

[Ben]

Sharon,

One thing I have done to prevent this is use '@if'
statements. Granted I am a beginner so there probably is
a better way to do it, but this is what I have used.

Example: @if(d1="","",@if(d1=0,"",c1/d1))

Sometimes I have it print an error to me also like "Need
Charge Rate" instead of the "".

HTTH
Ben

-----Original Message-----
I am trying to make a worksheet that will show a running

balance. I have been able to create the formula to do it
one row at a time. My problem is when I copy formula
down, and there is a colum with no number in it.

My spread sheet is like this:

A = deposit
B = Charge
C = Other Charge
D = Other Charge Rate
E = C divided by D
F = Balance


I want to copy the formula down, so when a number is put

in one of the colums, the balance will change. My
problem is that when you copy the formula down and there
is nothing in a cell, I get a #DIV/0 error on both E
colum and F.

Also, When I copy the F colum formula down, it gives me

the running total in all rows, even before I put
something in. Can it be blank until something has been
put in a cell?