software

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

Something like this maybe.

=if(b2=quot;quot;,quot;quot;,d3-b2 c2)

HTH
Regards,
Howard

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