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



"ggant" wrote:

I am trying to store a formula in a cell and evaluate when data is input.
Example; Credit Card Bal that lowers the available amount as it items are
posted. I want to store in many more cells.

F G
($9,000.05) $999.95
($7,697.25) $1,302.80
($7,627.80) $69.45
($7,252.80) $375.00
($6,920.82) $331.98
($5,880.82) $1,040.00
($4,368.40) $1,512.42
($2,910.45) $1,457.95
($2,655.30) $255.15
($175.80) $2,479.50
($75.80) $100.00
($72.80) $3.00
($71.80) $1.00

formula is : =SUM(F7,G8) in each cell.