Help

[huskym1025]

I have a little problem here.

Payment Balance
A1 B1
$0 $200
A2 B2
$50 $150
A3 B3
$150
A4 B4
$150


Here is my formula: =(B2-A2) in Cell B2. I am using 12 cells down to B12. In the following cells B3 down to cell B12 it displays $150. How can I get the cells to be blank. Thanks@

 

[arthurbr]

Perhaps =IF(A2="","",B2-A2) and pull down
The cleanest way is to keep your formula and Insert a table
Each time you add a value to col A col B will reflect the result automatically ( thus avoiding null strings)