Need help with formula please!!!!

[alexferfa]

I am trying to create a balance sheet and I am having a problem.

Column G is the balance
Column E is the checks
Column F is the Deposits

Lets say in the cell G4 I put my starting balance and on G5 I put the following formula =SUM(G4-E5+F5). I also put that formula on every cell of column G increasing the row number as I go down.

The problem I have is that on every cell that I put that formula it will show me the total balance, even if I don’t write any amount on the check or deposit column for that row.

I found a formula that helps me solve this problem,
=IF(ISERROR(IF(OR(E6,F6),((G5)+E6-F6),)),"",IF(OR(E6,F6),((G5)+E6-F6),))

The problem I have with this formula is that if I make the values of Check or Deposit 0, it will reset the value of my balance to $0 from that row and bellow and if I skip a row, which I do to mark when I have void check, it won’t show me any balance from that row and bellow.

Anyone have any idea or a formula to help me solve this?

[Carim]

Hi,

In cell G5, what about following formula

Please Login or Register  to view this content.

Does it help ?

HTH
Carim

[alexferfa]

Hi,

In cell G5, what about following formula

Please Login or Register  to view this content.

Does it help ?

HTH
Carim

If I skip a row, when I put a value in the following Check or Deposit row it will show me an error message #VALUE!

[Carim]

Hi,

Attached is a very simple solution ...

HTH
Carim

[alexferfa]

Hi,

Attached is a very simple solution ...

HTH
Carim

Thanks a lot

How did you do that? I saw you use the simples formula and you can't see the balance on the rows that you skip, but if you highligh the balance column then you could the the balance on the rows you skip.

How did you do that?

[Carim]

You are demanding ... lol
not only the solution but also the secret ... !!!

It is a simple conditional formatting formula ... check it out ...

Glad your problem is fixed.

Thanks for the feedback

Carim