software

The way your data is laid out...........it looks to me like in cell F8 you
would want this formula:

=F7-G8

Vaya con Dios,
Chuck, CABGx3
quot;ggantquot; wrote:

gt; I am trying to store a formula in a cell and evaluate when data is input.
gt; Example; Credit Card Bal that lowers the available amount as it items are
gt; posted. I want to store in many more cells.
gt;
gt; F G
gt; ($9,000.05)$999.95
gt; ($7,697.25)$1,302.80
gt; ($7,627.80)$69.45
gt; ($7,252.80)$375.00
gt; ($6,920.82)$331.98
gt; ($5,880.82)$1,040.00
gt; ($4,368.40)$1,512.42
gt; ($2,910.45)$1,457.95
gt; ($2,655.30)$255.15
gt; ($175.80)$2,479.50
gt; ($75.80)$100.00
gt; ($72.80)$3.00
gt; ($71.80)$1.00
gt;
gt; formula is : =SUM(F7,G8) in each cell.
gt;