Try this:

=IF(OR(F30,G30),H2+F3-G3,0) and copy down


HOWEVER, I would have thought you would want the balance on every line; if
so then
in balance column

=H2+F3-G3 and copy down

F G H
Credit Debit Balance
100
100 200
0 <==== Should this not be 200?
50 -50 <== and this 150?

HTH

"Horst" wrote:

I like to start with a balance in the row above. If I have a debit or credit
on the next row, I would like to calculate the balance cell on that row to
give me the new total. If there is no entry, I would like the balance cell on
that row to show 0 or stay blank. This should be like a regular check
register.

"Toppers" wrote:

Please explain what you want to happen .. just giving a formula isn't
sufficient.

"Horst" wrote:

That didn't work. I'm trying to create a running ledger but I don't want it
to automaticaly to configure unless the next entry has been posted.

"Toppers" wrote:

..... or do you mean...

=if(OR(F14=value,G14=Value),H3+F13-G14),0)

i.e if F14 OR G14 Value?

If both F14 AND G14 = Value then change OR to AND

=if(AND(F14=value,G14=Value),H3+F13-G14),0)


HTH

"Horst" wrote:

Can someone give me the right formula plase
IF(F14:G14=VALUE,SUM(H13+F14-G14),0)