Thanks Kassie-but it didn't help
 

Maybe I asked wrong, Example: Beginning balance $600
A B C D
1 Chk # Chk amount Deposit Balance
2 105 100 500
3 106 10 490
4 107 20 50 520
5 520
6 520
7 520
if b5, b6, and b7 are blank then D5,6 and 7 should be blank else =d3-b2+c2

Thanks Kassie-but it didn't help
 

Something like this maybe.

=if(b2="","",d3-b2+c2)

HTH
Regards,
Howard

"miltdp" wrote in message
...
Maybe I asked wrong, Example: Beginning balance $600
A B C D
1 Chk # Chk amount Deposit Balance
2 105 100 500
3 106 10 490
4 107 20 50 520
5 520
6 520
7 520
if b5, b6, and b7 are blank then D5,6 and 7 should be blank else
=d3-b2+c2